MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

IIF usage in Column Header Expression

  • Follow


 I am trying to turn Day of week column headings into the actual dates but 
get a #ERROR. The expression I am using is "Work Date: 
IIf([SLICE1]>0,[PERIOD_START],(IIf([SLICE2]>0,([Period_Start]+1))))" Once I 
get this working I will expand it to all 7 days. The database stores 
Period_Number, SLICE1, SLICE2, etc. in the Time_Reported table and 
Period_Number, Period_Start, & Period_End in the User_Period table. Both 
tables are in the query.  Thanks for any help, Alan
0
Reply Utf 9/14/2007 2:54:03 PM

microsoft.public.access 16776 articles. 71 followers.

0 Replies
344 Views

(page loaded in 0.02 seconds)

Similiar Articles:

IIF usage in Column Header Expression - microsoft.public.access ...
I am trying to turn Day of week column headings into the actual dates but get a #ERROR. The expression I am using is "Work Date: IIf([SLICE1]>0,[PE...

Reporting Services SUM(IIF(...) Problem - microsoft.public ...
IIF usage in Column Header Expression - microsoft.public.access ... Reporting Services SUM(IIF(...) Problem - microsoft.public ... IIF usage in Column Header Expression ...

Using IIF in expression builder in reports - microsoft.public ...
IIF usage in Column Header Expression - microsoft.public.access ... Using IIF in expression builder in reports - microsoft.public ..... each column ... 44 AM Header ...

iif expression and time format - microsoft.public.access ...
IIF usage in Column Header Expression - microsoft.public.access ... iif expression and time format - microsoft.public.access ... IIF usage in Column Header Expression ...

Rename Column in Header - microsoft.public.access.queries ...
IIF usage in Column Header Expression - microsoft.public.access ... IIF usage in Column Header Expression - microsoft.public.access ... IIF usage in Column Header ...

IIf Statement Error - microsoft.public.access.queries
IIF usage in Column Header Expression - microsoft.public.access ... IIf Statement Error - microsoft.public.access.queries IIF usage in Column Header Expression - microsoft ...

SSRS 2008 Condition Column Visibility Whitspace Issue - microsoft ...
IIF usage in Column Header Expression - microsoft.public.access ... SSRS 2008 Condition Column Visibility Whitspace Issue - microsoft ... IIF usage in Column Header ...

Printing a Repeated Section Messege like "Continued" ...
Set its expression to =1 and RunningSum property to Over Group. Then the header section text box can use the expression: =IIf(txtDetailNum > 1, "continued", "") You ...

Iif then statement needed for Access 2007 please - microsoft ...
Heather I'm not clear why you need to use an IIF() expression... Have you looked into ... ColumnA = 10, me.ColumnZ = "A","") Update Query: In the ColumnA column ...

IIf statement in query, Null value change to "0" ...
You would not use the expressions in criteria. You would use them as a calculated column (field) in a query. Field: IIF(OT is Null,0,OT) + IIF(DT is Null,0,DT ...

7/31/2012 6:07:29 AM


Reply:
Privacy Policy | All Times Are GMT(UTC) | powered by