time is going backwards in my database!!!

[oohmygod831]

Hi guys i need some help. i have a simple enough database that books tools in and out from a store. my problem is the date field i am using (Book_Date)

I have set its default value in its table to Now() and also in the form that i use to book in or out the Book_Now fields default on the form is Now()

my understanding is that this should return me the system date that was on the pc when i entered the record.

when i check my records however the date an time are counting backwards.

The date on the first record is 02/06/2008 21:38:15 and with each new record the date has receeded.

Book_Date
02/06/2008 21:38:15
02/06/2008 21:36:55
02/06/2008 21:35:09
02/06/2008 21:34:47
02/06/2008 13:49:29
02/06/2008 13:49:19
02/06/2008 13:49:06
02/06/2008 13:48:19
02/06/2008 13:47:53
02/06/2008 13:47:24
28/05/2008 10:49:35
28/05/2008 10:49:35
28/05/2008 10:48:54

Ive checked and the date field on the form (when entering new record) is set to a lower date/time than the previous entry even though the default is Now()

the last date in the list being the most recently entered and should read 07/06/2008 16:45:23

Any clues anyone? I have checked my system time and date and they are correct.

 

[boblarson]

Are you looking at the table when determining this? Just so that you know, records in Access are not necessarily stored in the order that they were entered. Use a query for the form and set the date to Ascending if you want to see it in order from earliest to latest, or Descending if you want to see it from latest to earliest.

 

[oohmygod831]

ive done that, i check my records using a query . when i am entering new records, the date is set on the form as default = Now() and i have a date field on the form so i can see the date being recorded but it isnt the system date, its way out and with each enry it seems to be counting backwards

 

[oohmygod831]

dont know what i have done but i closed my database , copied it and deleted all the un needed rubbish as i was going to post a copy for you to lok at and lo and behold it is working fine. God only knows what was up with it.

 

[neileg]

By the way, Now() returns the system date and time as you have seen. If you only want the date, use Date().