all records from one employee

[CoachPhil]

Gang,

I have a report based on a query where I would like to pull one employee from the query, then all recordsets associated with that employee. I have been at this for a while and am missing the obvious, any help would be appreciated.

CoachPhil

 

[pbaldy]

This technique works for OpenReport too:

http://www.baldyweb.com/wherecondition.htm

 

[CoachPhil]

Thanks Paul, I'll give that a try.

CoachPhil