I am fairly new with access and I have been using Access 2002, 2003, 2007 and 2010 as no one in my office has the exact same version (a huge issue, but not important at the moment). I am having trouble with a query grouping some of my information. It is a SIMPLE query linked to a table with the following fields: [Sub-total], [Shipping], [Sales Tax], [Total], and [Date Added]. I am simply totalling the first 4 fields and sorting them by the date they are entered. HOWEVER, the information in the table is inputted using a Simple form into the table with the following fields: [Date of Purchase], [Record #], [Sub-total], [Shipping], [Sales Tax], [Total], and [Date Added].
The very last field, [Date Added], is automatically added using the Timestamp feature of Access, and this is where the issue begins. If I manually enter the [Date Added], my query will group the records accordingly. BUT when I use the form to enter the record, the query is not grouping the items on the automatically generated Date, it is simply displaying all of them. Basically Access is not grouping anything that has the automatically generated Timestamp field on it, but if it is manually entered, it groups appropriately. What in the world am I missing??? Below is the output of the query currently, dates 4/23/2012 through 4/25/2012 were manually added to the table and 4/26/2012 was automatically added using a simple input form.
-Anthony
Sum of Sub Total Sum of Shipping Sum of Sales Total Date Added 259.45 18.75 .75 278.95 4/23/2012 465.49 111.20 0.00 576.69 4/24/2012 373.11 131.64 3.20 507.95 4/25/2012 250.00 15.00 2.25 267.25 4/26/2012 20.00 2.00 2.00 24.00 2/26/2012 40.00 3.00 2.00 45.00 2/26/2012