Results 1 to 4 of 4
  1. #1
    ANC-AB is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Jan 2012
    Posts
    3

    Probably a simple solution, but I am stuck

    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

  2. #2
    recyan's Avatar
    recyan is offline Expert
    Windows 2K Access 2000
    Join Date
    Dec 2011
    Posts
    662
    Not sure, just check whether the Date added automatically, has also the Time value in it. That could be the cause.
    If that is the case, then perhaps something like DateValue, ...

    Thanks

  3. #3
    ANC-AB is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Jan 2012
    Posts
    3
    Thanks for pointing that out, I didnt even realize that I put Now() in the Default Value Property instead of Date(). Even though I had the Format set to Short Date, the value's still contained the time, by putting Date() it now only contains the date and does exactly what I want. Thankyou again.

  4. #4
    recyan's Avatar
    recyan is offline Expert
    Windows 2K Access 2000
    Join Date
    Dec 2011
    Posts
    662
    H2H - Happy 2 Help.

    Thanks

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Document Management Solution
    By mjblay in forum Access
    Replies: 1
    Last Post: 12-09-2011, 08:49 AM
  2. Help for Database Solution
    By ritorocking in forum Access
    Replies: 2
    Last Post: 05-17-2011, 09:46 AM
  3. DLookup or Other Solution
    By IFA Stamford in forum Access
    Replies: 3
    Last Post: 12-31-2010, 11:18 AM
  4. Corrupt Database: Possible solution?
    By asearle in forum Access
    Replies: 2
    Last Post: 07-14-2010, 01:59 PM
  5. Best solution
    By geeka in forum Access
    Replies: 1
    Last Post: 12-04-2006, 01:12 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums