Parameter Query

  • Thread starter Thread starter Alexander
  • Start date Start date
A

Alexander

Dear all,

I have two field, "Begining Date" and "Ending Date"

I would like to make a paramater query to prompt the user to key in a
begining date and a ending date, and it will show all the data within the
two date range.

What should I do?

Thank You.

Cheers!
 
Dear all,

I have two field, "Begining Date" and "Ending Date"

I would like to make a paramater query to prompt the user to key in a
begining date and a ending date, and it will show all the data within the
two date range.

What should I do?

Thank You.

Cheers!
Click to expand...

In Access the Query
SELECT *
FROM Table
WHERE FieldDate BETWEEN #ValidStartDate# AND #VALIDENDDATE#;

Will actually work.

I might even suggest putting 2 textFields and a control
on a main form, then using a subform linked to nothing
whose RecordSource would change to match the above
query (regenerated with the new textfields) on every click of the
control.

Or you could use a recordset

Hope that helps

-mwalts
 
Back
Top