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

But Access cannot be used to do the reporting, Crystal must do the job

The following would work, but can Crystal do it.

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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top