Results 1 to 2 of 2

Thread: MS Access help

  1. #1
    Join Date
    Aug 2007
    Posts
    1

    Unanswered: MS Access help

    Hi guys
    Looking for some help if able. The below may be very simple but i dont know Access that well and so need some advice.

    I have created a DBase in Acccess base on the following information:-
    RMA #
    company
    address
    unit
    DHL Ref
    Returned
    Date.

    There are more but no need to list them really. The record is to keep a running log of all cases passed to DHL. I have set up the basics in that all data is entered into the record. I have a date stamp on each record and this is where i need help

    Each day at 14:30 my dept emails all records created from 14:30 the previous day to DHL.
    I need to figure out how i can run a query/report that will return all case's logged in the last 24hrs at 14:30? based on the time stamp on the record?

    Once this one is sorted i need to run a report on all outstanding cases that have not been marked Returned (yes/no) in a month or a given date range.

    Any help would be fantastic

    If you need examples or the DBase for viewing please pm or email me.

    darren

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    This type of thing should work based on a date input on a form:

    Between CDate([Forms]![FormName]![ControlName] & " 14:30") And CDate(DateAdd("d",1,[Forms]![FormName]![ControlName]) & " 14:29")
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •