Only need one record...

[Guest]

I'm creating a report for guys to take out to the field with them. I want
just one record (with certain information pulled from a query) in the page
header section and blank boxes in the detail section. That's all done: the
report layout is just the way I want it, but the report shows a page for each
record. I only want one record shown for each individual Work Order...thus,
giving me one page per Work Order. How do I set a filter so that only one
record is shown?

Thanks,

 

[Duane Hookom]

Chekck this link http://www.fontstuff.com/access/acctut08.htm

 

[James Graf]

In the query find an ID or specific column and in criterea type
( [Which ID] ) so when you click your PRINT comand button it will ask
you Which ID then type it in. Use the brackets [ ] not the ().