[amre]

I have a strange issue with a query in an access 2003 database that I am running.
The query should list data from sales that were made today from date() in the criteria.
I used the database yesterday(04/04/2012) and it worked ok, although nothing has been changed
it is now not showing todays sales(05/04/2012).

I changed the date on my computer to (04/04/2012) and the query works fine.
So I tried changing the date on my computer to various dates, the query worked on
some dates but not others.

I am not changing anything on the query or any part of the database.

Has anyone any ideas on the reason for this, and if there is a solution??

[June7]

Only cause I can think of is international date formats. Review http://allenbrowne.com/ser-36.html

[amre]

Yeah i thought it must be something to do with that, and i had already checked the database date formats.
after reading your post I realised that i forgot to check the Visual basic bit..... it was formatted wrongly. I feel a bit stupid now for never noticing this before.
Thanks for your help anyway.