Two Columns of same fields in query

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

I need a query to report 2 columns of the same field, but with different
criteria. Example: [Type] Criteria of "Like16" and [Type] Criteria
of "Like 17" This way I can have two columns in a report. Can I do this?
Thanks..Randy
 
Do not use criteria but column labels. Try this --
Type 16: Iif([TYPE]=16, "Yes", Null)
and next column --
Type 17: Iif([TYPE]=17, "Yes", Null)
 
Back
Top