M
MNY Intern
I have a report based off a crosstab query. The query changes daily based on
hours worked. If there are no hours worked, there is no field for that day.
For instance: Today is Thursday, so no field would exist for Friday because
obviously no one has worked a day that hasn't yet come. I want this report to
show Sunday thru Saturday columns regardless. I've tried using IIF statements
to say IIF(IsError([1]), 0, IIF([FT/PT]="F", 8-[1], 3.5-[1])), but this
doesn't work because field [1] does not exist (meaning no Sunday hours
worked). My fields are all based on a day of the week code, so Sunday is 1,
Monday is 2.. etc.
Is there a way i can say if the field doesnt exist, display 0, else return
the value?
hours worked. If there are no hours worked, there is no field for that day.
For instance: Today is Thursday, so no field would exist for Friday because
obviously no one has worked a day that hasn't yet come. I want this report to
show Sunday thru Saturday columns regardless. I've tried using IIF statements
to say IIF(IsError([1]), 0, IIF([FT/PT]="F", 8-[1], 3.5-[1])), but this
doesn't work because field [1] does not exist (meaning no Sunday hours
worked). My fields are all based on a day of the week code, so Sunday is 1,
Monday is 2.. etc.
Is there a way i can say if the field doesnt exist, display 0, else return
the value?