Correct saving my date

Oct 17 2012 2:05 PM

I have a table which has four fields in ms access

Oid(Number) Odate(Date) Dr(Number) Cr(Number)

Req(Yes) Req(Yes) Req(No) Req(No)

I use two Forms to add record and edit record

When I add a record with the date 01/10/2012. It will save as dd/mm/yy Format

When I modify to enter odate and oid it will retrieve it but when I save.

After save again I want to edit agian this entry but it is not matching the record because

It has been saved before in the format mm/dd/yy

Please help me again this problem

Answers (2)