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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Append queries - Column Headers 2
Using a field reference in a query critereon 0
Duplicate Query based on two duplicates 7
Use In() Expression as Query criteria with guts from Function 1
Parameter Query multiple criteria help 6
Help with expression builder in a select Query 2
Multiple Parameter Crosstab query filter by form 1

Back
Top