No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
4 Posted Topics
[quote=nelly_1005;101804]Hi GUys Just wondering if any one can help me out. Basically i wnat to create an SQL query which will take the input of the user and query that specific variable: e.g the user enetrs in a field, the value entered is assigned to variable "srch", then in my …
[quote=hamerw;277081]Hello I have successfully exported a recordset to an Excel template and saved the template as an xls file. However, when I open the Excel file all the worksheets are hidden. Does anyone know why and how to stop this from happening. thx Wayne[/quote] Hi... have u use macro for …
[quote=hvelador;252340]Hello everyone, I have an Access question. I have two date fields (field 1 & field 2), and both are formatted for "General Date". Since they are used in a calculation of Date and time, I need both segments to be entered. What expression can I input into the "Validation …
[quote=jlopez;259741]IF your are putting this expression inside your calculated control, you can revise this one because in immediate iif statement you cannot put else statement IIF([P1]<=4,"100%",IIF([P1]>12,0),IIF([P1]=12, 12-[P2]/12, "this will handle your else condition" ))[/quote] Hi... u have problem in IIF([P1]<=4,"100%",IIF([P1]>12,0,IIF([P1]=12, 12-[P2]/12, "this will handle your else condition" )))
The End.