Report or query from user inputed date

[Nigel Molesworth]

I want to create a report (if necessary, it can be a query) that asks
the user to input a date. The result would contain only those records
whose date field has the same or later date.

I'm sure it's possible, but I don't know how to get the user input!

 

[Arvin Meyer [MVP]]

Use a query as the recordsource for the report. In the criteria box of date
column of the query's QBE grid, type the expression:

=[Please Input a date]

or any text between the 2 square brackets that makes sense to you. You can
also supply the date from a form by using the syntax:

=[Forms]![YourFormName]![YourDateControlName]

of course substituting the correct names.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Nigel Molesworth]

Use a query as the recordsource for the report. In the criteria box of date
column of the query's QBE grid, type the expression:

Hi Arvin,

Thanks for your replies to both my questions. Could I ask that you
give me a bit more info, I'm a novice with Access.

 

[Nigel Molesworth]

Use a query as the recordsource for the report. In the criteria box of date
column of the query's QBE grid, type the expression:

Hey, what do you know! I figured out what all those words meant and it
works, many thanks.

 

[Arvin Meyer [MVP]]

Hey, what do you know! I figured out what all those words meant and it
works, many thanks.

.... Teach a man to fish ...

You're quite welcome.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Douglas J. Steele]

... Teach a man to fish ...

....and he'll eat sushi! <g>

 

[Arvin Meyer [MVP]]

For the rest of his life
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access