Report based on various criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create an "Early Bird" report based on several different fields
each with it's own criteria. I am having trouble combining the information
into one query.

I have one table which lists each youth plans. Weekly, the "early bird" is
updated and we print a report showing all of what is due and/or late to be
turned in. We used to do this in excel, but we would like to start tracking
this information in Access.

This report has separate fields one is ITP, MTP, MTPU, etc. each report that
has not been turned in also must include the youth's name & the day it is
due. i.e.

Baxter, Dendalee ITP 6/7/06
Holcomb, Satin MTP 6/22/06

How can I pull up this information in one report?
 
Must the results meet ALL of the criteria or ANY of the criteria?

If must meet ALL then place all criteria on the same row of the query in
design view grid.

If must meet ANY then place the criteria on a separate row in the grid.
 

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

Open a report based on form fields 4
Access Access Report Works on One Machine but not Another 3
Basing Report on Crosstab 3
Date Range Query. Criteria based in a table. 4
Report that calculates based on another field's criteria 2
Report based on form value 7
reporting even though a calculation made is dividing by zero 14
Open Report with Criteria From Form 6

Back
Top