Results 1 to 2 of 2
  1. #1
    howsle is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    1

    Question Billable Days within date range

    I have an inventory which I bill various users for storage on (each item is a separate line item). I record the day storage began as one field and the date storage is closed as another.



    I need a report to generate the number of billable days each month for storage for each item in inventory. So, I need to have access look at each "began date" and generate the number of days in each month storage took place til the "close date".

    Is this possible? I am flexible on how to get this information. I am an ACCESS NOVICE!

    Thanks in advance.

  2. #2
    ketbdnetbp is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Midwest
    Posts
    254

    Howsle -

    Search the help section for the DateDiff() function. See if that gets you what you want.

    All the best,

    Jim

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

Similar Threads

  1. Replies: 8
    Last Post: 09-23-2012, 01:05 AM
  2. Run Query based on date for Multiple days
    By jedwards85 in forum Access
    Replies: 3
    Last Post: 03-29-2011, 12:04 PM
  3. Replies: 2
    Last Post: 04-27-2010, 01:25 PM
  4. Replies: 2
    Last Post: 07-31-2009, 06:56 AM
  5. 90 days in the pass - Date help wanted
    By techexpressinc in forum Queries
    Replies: 1
    Last Post: 01-26-2009, 07:13 AM

Tags for this Thread

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 - Senior Forums