Access Query (Access 2003)

Topic

New Reply

I have set up a parameter query with a Between Start & End date. That works fine – except I need the end date to become a field in my query. I tried this with the Between, then 2 new fields Start & End – it now asks me 4 times for the Start & End date.
Thank you in advance.

Reply | Quote

Replies

The screenshot below shows a way to do this. The parameter prompts will be for Start Date and Last Date, the query will have a column named End Date.

Reply | Quote