The data type in Access is "Date/Time". Yes, at first I thought Access does not store the milliseconds information as well because when I open the table up in...

There are only smalldate, timestamp and datetime for the datetime format. Tried them all, did not make a difference.... I still don't see the milliseconds after the import.

Yes, I tried Import Wizard and also create a linked server to the mdb file and query the table directly.... still not seeing the milliseconds.

Thank you so much!! You are the BEST!

The date column should be in ascending order similar like the rowid, however I have data that the date is not in ascending order and I would like to identify...

Thank you so much Wayne! Your solution works perfectly!! I will keep your advise in mind about asking for help next time.

You guys are the best!:-D

Thanks a lot hester84!! It works!!

However, if I would like it to show the number of max concurrent users per day for a month of April, how can I...