Code:
=Sum(IIf([TR_end] Between #01/08/2011# And #31/07/2011# And [agecode]="1" And [PROGTYPE] Not Like "99",1,0))
Madmonty
Last Activity: Apr 18 '12, 12:32 PM
Joined: Oct 3 '11
Location:
-
Delay Display in Access Reports
I have designed a yearly report that gives a snapshot of data at the start of each month with a contract year running from 1st August 2011 to end of July 2012. The snapshot uses various fields and uses variations of the following code:
Is there anyway I could enable this to not display all the... -
Thank NeoPa! That worked a treat!! You're a star!! -
IIF(OR possible in Access?
PLEASE HELP!!
I am trying to build an expression in an Access report that looks at a Main Query (record source of all learners) and asks it specific questions. I am basically trying to write an IIf statement similar to below with an OR clause. I know it is wrong because the OR clause messes it up when I build the expression, but what I am trying to ask Access is
[CODE]=Sum(IIf([TR_Start]<#01/08/2011# And [TR_End]... -
zepphead! many thanks! I built a table with all the possible variations of the codes and linked it to the main data via a joined query. It now works a treat!! Thank you! :-)Leave a comment:
-
Help on complex IIf statement please!
I am trying to decode some set data (in codes) to a description. In Excel I would use a VLookup, but am struggling to write the expression in Access. I have built this into a column in a query, but Access is saying that the 'expression is too complex'. Any help on overcoming this would be greatly appreciated.
...Code:SSADESC: (IIf([SSA2011] Like "01.3*","Health and Social Care",(IIf([ssa2011] Like "01.5*","Child
Last edited by NeoPa; Oct 3 '11, 04:22 PM. Reason: Added mandatory [CODE] tags for you - BTW Nice ID
No activity results to display
Leave a comment: