Stuck with dates

[Robbeh]

Hello there,

I'm making a database for a friend who works for a small magazine.

I'm trying to write a simple query so that she can product a list of all the people who the magazine should be sent to.

Each customer has an 'end issue date' (that is the date at which their subscription expires).

So, in the query wizard, for the field 'EndIssue' I've put the following in 'Criteria'.
<=[Enter the issue date]

If I run the query with the date '01/02/2008' I come up with 170 matches. However, if I run it with the date '01/01/2008', I come up with zero.

Damn!

Does Access handle dates in some funny way?

I have a simalar problem with checkboxes?

I'd be really grateful to anyone who could offer some help!

Cheers,
Rob

 

[Jon K]

Make sure the EndIssue field in the table is a Date/Time field, i.e. not a Text field.

And make sure the date entered when the query is run follows the system date format, i.e. whether it should be mm/dd/yyyy or dd/mm/yyyy.


For parameter queries, it would be better to let the user enter the parameter value in a text box on a form than prompt the user with a dialog box when the query is run, for the user can see the value in the text box after the query is run.

To reference the text box on a form, you can simply change the criteria in the query to:
<=[Forms]![yourFormName]![theTextBoxName]
.

 

[Rabbie]

Also remember if you are using a literal date to enclose it with # characters like #1/1/2008#

 

[Robbeh]

Thanks so much guys! You solved it