Hi there,

I am having a weird date problem and I just cannot figure out why.

I have some date data in a table which when I pull all of them and put them
in ascending order looks like this:

10/2/2006
10/20/2006
10/22/2006
10/24/2006
10/24/2006
10/29/2006
10/30/2006
10/5/2006

The problem record is the last one which will not sort correctly. I have
double and triple checked to make sure the data is in Short Date format.

For reports I simple cannot get the problem record (10/5/2006) to display
when i specify a date range that would normally include it. I am having this
problem with a few random date records in the database.

I have even reformatted it: : Format([DateRecord],"Short Date") to ensure
that it in indeed in the correct format and even used the same formatting yet
again in the criteria to ensure it is also in the same format. Yet a few of
the records simply do not want to cooperate.

Anyone have an idea why?

Thanks