Simple query not working

[Guest]

I have a simple query as follows

SELECT * FROM [tbl_History] WHERE [HistReceiptDate] = 02/10/200

where [HistReceiptDate] is a date field of format "mm/dd/yyyy

This query will not find any records even though records with this date definitely exist in the table

Why does this query not work

ctda

 

[Duane Hookom]

Try:
SELECT * FROM [tbl_History] WHERE [HistReceiptDate] = #02/10/2004#
Keep in mind that this is Feb 10th, not Oct 2nd.

 

[Guest]

Thanks. That did it. I'm obviously a novice with SQL query statements
ctda

----- Duane Hookom wrote: ----

Try
SELECT * FROM [tbl_History] WHERE [HistReceiptDate] = #02/10/2004
Keep in mind that this is Feb 10th, not Oct 2nd

--
Duane Hooko
MS Access MV

I have a simple query as follows

SELECT * FROM [tbl_History] WHERE [HistReceiptDate] = 02/10/200
where [HistReceiptDate] is a date field of format "mm/dd/yyyy
This query will not find any records even though records with this dat definitely exist in the table
Why does this query not work
ctda

 

[John Vinson]

I have a simple query as follows:

SELECT * FROM [tbl_History] WHERE [HistReceiptDate] = 02/10/2004

where [HistReceiptDate] is a date field of format "mm/dd/yyyy"

This query will not find any records even though records with this date definitely exist in the table.

Why does this query not work?

ctdak

Because it's treating 2/10/2004 as an arithmetic expression giving
..0000998 as the answer (which will match a date/time of 12:00:08am on
December 30, 1899).

If you want it to be treated as a Date, use # as a delimiter:

SELECT * FROM [tbl_History] WHERE [HistReceiptDate] = #02/10/2004#;