Query with two different criteria as table in report

  • Thread starter Thread starter Sharon M via AccessMonster.com
  • Start date Start date
S

Sharon M via AccessMonster.com

Hi there

I have created a union query that returns data with "critical" and
"concurrent" delays.

I now want to place them in different columns of a report as so:

Date Description Concurrent Critical
1/11/02 MET 0 1

Based on the criteria i have written into the report for concurrent:
= iif([Delay_Type] = "concurrent", [delay_hours],0)
= iif([Delay_Type] = "critical", [delay_hours],0)
but returns an error, is my logic curly?
 
Sharon said:
I have created a union query that returns data with "critical" and
"concurrent" delays.

I now want to place them in different columns of a report as so:

Date Description Concurrent Critical
1/11/02 MET 0 1

Based on the criteria i have written into the report for concurrent:
= iif([Delay_Type] = "concurrent", [delay_hours],0)
= iif([Delay_Type] = "critical", [delay_hours],0)
but returns an error, is my logic curly?
Click to expand...


Logic looks ok. Check to make sure the text box is NOT
named delay_hours (or Delay_Type).
 
Thanks Marshall, you were right, one the text box did share the same name, so
now works ok.

Thanks again
Sharon

Marshall said:
I have created a union query that returns data with "critical" and
"concurrent" delays.
Click to expand...
[quoted text clipped - 8 lines]
= iif([Delay_Type] = "critical", [delay_hours],0)
but returns an error, is my logic curly?
Click to expand...

Logic looks ok. Check to make sure the text box is NOT
named delay_hours (or Delay_Type).
Click to expand...
 
Back
Top