About Rob Henderson Expertise I can answer most MS Access design questions. I also welcome questions on database design and implementation and VBA programming questions.
I also have expierence in application design for all the Office components (Excel, Outlook, etc).
Question hi,
i want to construct a report by using queries. example, in my form i have let the user to choose the period = 1. then i want the system to generate report by looking at the query which will extract only the period = 1 from the underlying database. so therefore i want the report to only have data where period = 1. how do i go about doing this? i hope u ccan help me. thank u very much SIR!
SUDHA
Answer Hi
You could do this two ways.
Using VBA to manipulate a query def or set a parameter in the criteria row.
I.e.
In the criteria row of your query put...
[Enter number]
When the query executes it will prompt the user for a value. Then the query will return the records that meet the value criteria.
Beware.
This is not an ideal way to handle this as the user may not enter anything or something it is not expecting like text.
