Simple Query/Date issue (I Hope)

[Randy]

There is probably a simple answer to this. I have a query with several
fields of: DateIssued, EmployeeID, Fees, etc. My table has an imput mask
for the dateIssued of 99/99/00; My form allows me to enter 1/3/05 with no
problem. The table shows 1/3/2005. My query has a criteria of : Like
[Please Enter Date] When I run my query I must enter all 4 digits of the
yesr for it to fire. If I enter 1/3/05 I get a blank result...Any
ideas..Thanks Randy

 

[John Spencer (MVP)]

Don't use like, use =.

If you use Like, Access helpfully changes the date into a string. When it does
so, it is evidently making the string show a 4-digit year. It makes the change
because LIKE is designed to work with strings, not dates or numbers.

 

[Randy]

That was it. Thanks John

Don't use like, use =.

If you use Like, Access helpfully changes the date into a string. When it
does
so, it is evidently making the string show a 4-digit year. It makes the
change
because LIKE is designed to work with strings, not dates or numbers.

There is probably a simple answer to this. I have a query with several
fields of: DateIssued, EmployeeID, Fees, etc. My table has an imput
mask
for the dateIssued of 99/99/00; My form allows me to enter 1/3/05 with
no
problem. The table shows 1/3/2005. My query has a criteria of : Like
[Please Enter Date] When I run my query I must enter all 4 digits of
the
yesr for it to fire. If I enter 1/3/05 I get a blank result...Any
ideas..Thanks Randy