Dynamic Reports

F

ftbadolato

I have a Customer table that has customers divided into different
types. I want to create one label report, but have it prompt me for
the type of customers I want to see on the report. How can I do
this? I'd also like to be able to make it give me all the customers
that were recently added. Basically, how do I incorporate variables
into a report?
 
K

KARL DEWEY

have it prompt me for the type of customers
Use an unbound listbox to select type.
Then in your query criteria use this --
[Forms]![YourFormName]![YourListBoxName]
What constitues 'recently added?' Are you wanting ONLY the recent ones or
a flag of the recent ones?
 

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

Similar Threads

Access 2002 change report header text 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
ASK Field Formatting 1
Show week number in Project Report 0
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
Word 2016 - Difficulties Learning Style Creation/Application 0
Copy previous record into form field 0
VBA to look for more than 1 key word and highlights 8

Top