Reporting out multiple fields

[Ted Sylvio]

Hi,

I'm importing a years worth of timesheets for my company from Excel into
Access. So far I have been able to produce many nice looking reports with
useful information that used to take us days to sort through in Excel.
However the problem emerged when there is a category that involves multiple
tasks that we need to timetrack. To give an example lets say we are looking
to see whos involved in the mailroom procedures and they could have entered
three tasks on their timesheet like sorting, sending and receiving. I tried
to use a conditional iif statement to get what i wanted. My code looked
liked:

=iif ([Sheet1.Task] "SORT", "SEND", "REC")

Everytime I try to run the report the field where the number should be shows
"#Name?"

Can anyone shine some light on this? Thanks in advance!

 

[Douglas J. Steele]

The IIf function requires three arguments: a boolean expression, an
expression to return if the boolean expression is True, and an expression to
return if the boolean expression if False.

Your first parameter isn't a boolean expression: it would need to be
something like [Sheet1.Task] = "SORT"

 

[Ken Sheridan]

Hi,

I'm importing a years worth of timesheets for my company from Excel into
Access. So far I have been able to produce many nice looking reports with
useful information that used to take us days to sort through in Excel.
However the problem emerged when there is a category that involves multiple
tasks that we need to timetrack. To give an example lets say we are looking
to see whos involved in the mailroom procedures and they could have entered
three tasks on their timesheet like sorting, sending and receiving. I tried
to use a conditional iif statement to get what i wanted. My code looked
liked:

=iif ([Sheet1.Task] "SORT", "SEND", "REC")

Everytime I try to run the report the field where the number should be shows
"#Name?"

Can anyone shine some light on this? Thanks in advance!