Data Type Mismatch ? using form with date 1

[Dylan]

I have a ? concerning a query that keeps giving me a "data type mismatch" when the qry runs. the criteria looks for 2 date flds being equal. One fld is from a table (data type = date) and the other fld is on a form as a text box with a format of short date. Can you help me with this ???

Thanks tom

Tom Moran
Lansing, Michigan

 

[willir]

Tom

You may consider encapusulating the date field with the Access date delimiter, "#"

If MyDateField = "#" & MyTextField & "#" Then
....

Richard

 

[willir]

...better yet.

If MyDateField = "#" & CDate(MyTextField) & "#" Then

The CDate() function verfies the enclosed variable is a date.

 

[Dylan]

Hi Willir,

I tried it but got mismatch error again ...

Heres the qry

SELECT Count(tbl_spet.tbl_batch_date) AS RecCnt, tbl_spet.tbl_batch_date INTO tbl_count
FROM tbl_spet
GROUP BY tbl_spet.tbl_batch_date
HAVING (((tbl_spet.tbl_batch_date)=("#" & CDate([Forms]![frm_main_menu]![frm_lockdate]) & "#")));


Tom Moran
Lansing, Michigan

 

[willir]

[tt]
SELECT Count(tbl_spet.tbl_batch_date) AS RecCnt, tbl_spet.tbl_batch_date INTO tbl_count
FROM tbl_spet
GROUP BY tbl_spet.tbl_batch_date
HAVING (((tbl_spet.tbl_batch_date)=CDate([Forms]![frm_main_menu]![frm_lockdate])));
[/tt]

 

[Dylan]

THANKS MUCH ... works like a charm !!!!!!!!!




Tom Moran
Lansing, Michigan