WHERE filter in access

Guirg

Registered User.
Local time
Today, 01:38
Joined
Jun 2, 2009
Messages
96
Hey

This may sound very odd but when i run a where statement in a RecordSource, >= works fine it includes the number, but when i run <= or = it wont :S ahahah sounds dumb but its got me stumped...

Cheers

Tim
 
Would help if you posted the whole sql statement

David
 
Oh yeah that would make sense, sorry
Code:
SELECT * FROM qryElectronic WHERE [DateRun]<=#4/20/2009#;
Wont include the date of the 20th, however
Code:
SELECT * FROM qryElectronic WHERE [DateRun]>=#4/20/2009#;
Will and whats even odder
Code:
SELECT * FROM qryElectronic WHERE [DateRun]<=#4/21/2009#;
will include the 20th... and on the same token
Code:
SELECT * FROM qryElectronic WHERE [DateRun]=#4/20/2009#;
returns an empty field...
 
How are you storing your dates in the table? dd/mm or mm/dd

David
 
the datas stored as dd/mm but the filter filters in mm/dd so i have a little subroutine to pull it appart and put it back together without the user knowing... the thing is the where statement works for all the other forms except this, and i have a feeling its the = sign
 

Users who are viewing this thread

Back
Top Bottom