Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multi Pass reports

Status
Not open for further replies.

MIKElaw

Programmer
Nov 4, 2000
116
GB
I have an Access database with two fields of interest: ORDER and FLAG

Pass 1 collects all records with FLAG = 2
Pass 2 collects all records where ORDER was found in the first pass

Final reports sorts on ORDER

Any ideas

 
Why two separate passes?

Crystal can check both conditions in one pass, as long as the records are in the same table (or two tables that can be linked), and the fields are in the same record or in the same row of the query.

Clarify what you mean by "Order was found". Does that mean that the field was filled in?



Ken Hamady
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top