Recent content by hcoffin1941

Thanks for taking the time to reply. Ok, I understand that access does not store the data in any particular order, but I still need my data in the table to appear in date sequence. The table contains a primary index field that contains a unique number starting with 1. This field is an...

I have an Access table with transactions that were entered in random order. I need to recreate the table with those transactions entered in date order. I started by making a copy of the table (table structure only) then creating an Append Query sorted by the date field thinking that the...

In Excel, month(DateField) = month number. I cannot find a similar function in Access. I am running Access 2010. Thanks,