Results 1 to 2 of 2

Query trying to total up the first date and insert in report

  1. #1
    nick243 is offline Competent Performer
    Windows 7 64bit Access 2002
    Join Date
    May 2016
    Posts
    166

    Query trying to total up the first date and insert in report

    I have these 3 records and I am trying to understand how to take the first unscheduled date and add records and totals specific to that day.



    Schduled
    WE 12/08 Unscheduled
    WE 12/15 Unscheduled
    WE 12/22 Unscheduled

    I want to take the first Weekending date 12/08 and find all the vendors and carriers units that are coming in that day. I can't seem to narrow it down to just the single date. Any tips would be appreciated.

    Thanks,
    Nick

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    13,111
    Nick,

    I'm not following the logic/details, but would offer this for consideration.
    Access has a Date/Time datatype and I recommend you use it. It is designed to handle Day, Month, Year and Time units if needed. It will make calculations with intrinsic functions (DateAdd, DateDiff etc) easier to work with.

    Also, it is best to have 1 fact in 1 field in relational tables. I'm not sure what/how your 3 records are "dimmed/defined".

    Seems weekending date is the Saturday of each week.
    We don't know anything about
    vendors and carriers units that are coming in that day.
    More details and clarity will help get more focused responses.
    You may get some insight from this free, generic data model at BarryWilliams' site.

    Select * from Deliveries where Delivery_date ......your criteria go here

    Good luck

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

Similar Threads

  1. Replies: 3
    Last Post: 12-31-2014, 09:11 AM
  2. insert a specific date in report footer
    By Rasha in forum Access
    Replies: 3
    Last Post: 04-23-2014, 11:12 AM
  3. Total query with date/time fields
    By Ruegen in forum Queries
    Replies: 8
    Last Post: 09-03-2013, 04:32 PM
  4. Report Total from a query
    By Lorlai in forum Reports
    Replies: 5
    Last Post: 06-14-2013, 06:47 AM
  5. Total all months in query or report
    By Brian62 in forum Queries
    Replies: 2
    Last Post: 10-23-2009, 07:41 AM

Posting Permissions

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