Dynamic Reports

  • Thread starter Thread starter ftbadolato
  • Start date Start date
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?
 
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?
 
Back
Top