Query Returning Strange Results

[MadCatmk2]

Hi all

This problem is driving me up the wall!!!!!

Hopefully someone can help or suggest a reason as to why its happening.
I'm using Access 97 to query a table of contact details. Firstly i have this query:

SELECT BM_CON.*
FROM BM_CON
WHERE (((BM_CON.DATE_OF_VISIT)=#4/27/2004#) AND ((BM_CON.PATIENT_NO)="bm1882"));

This returns one record which is correct. Heres where the problem arises. Using this query returns several values but not the one returned in the first query(Which i am sure it should.

SELECT BM_CON.*
FROM BM_CON
WHERE (((BM_CON.DATE_OF_VISIT)=#4/27/2004#));

Does anyone know why the record should appear in the first query results but not in the second.

Any help is much appreciated.

Thanks in advance.

 

[MadCatmk2]

Sorry. Think i've solved it. Database i was using seemed to have a corruption. A repair on the database sorted it.

Thanks anyway