Report filter

A

Amateur

Dear Sirs

I have a report, named "Contacts" with a field named "Salesperson", based on
a table. I would like that, before the report opens, a pop-up appears asking
me for the "salespersonID" so that I only can see records from that specific
salesperson.
Can someone tell me how to do that?

Thanks in advance
Klaus
 
A

Amateur

Dear Sirs,
Changed my Report Data instead from a table to a query.

I have a report, named "Contacts" with a field named "Salesperson", based on
a QUERY. I would like that, before the report opens, a pop-up appears asking
me for the "salespersonID" so that I only can see records from that specific
salesperson. Can some tell me how to write the criteria for the
SalespersonID field?

Thanks
Klaus
 
M

Maarkr

Didn't say if you fixed it or not... just make your query a parameter query
by putting something like [Enter the SalespersonID:] in the criteria of the
SalespersonID field, and your report should then require a valid ID before
executing.
 
Top