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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top