Expert: Rob Henderson - 6/10/2004

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.

HTH

Rob