Results 1 to 2 of 2
  1. #1
    zac123 is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    17

    Question fuction elapsed time, expression builder

    ok, me again

    ive got a saved function that calculates the time between two sets of dates/times.

    ive saved the fuction and now i'm trying to use it.

    field 1 has the start date and time
    field 2 has the end date and time
    field 3 should hold the result of the elapsed time fuction

    my question is this.

    when i click field 3 then choose '...' (Control Source) i'm using the expression builder and this is what ive got so far:

    ResponseTime «Expr» ElapsedTimeString («dateTimeStart», «dateTimeEnd»)
    can somone tell me exactly how to get the values of field 1 & field 2 in there please?

    many thanks in advance


    zac

  2. #2
    zac123 is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    17
    a ha, got it. i just needed to add:[] around the names of the fields

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

Similar Threads

  1. Expression Builder or VB ... Help
    By Adynn in forum Access
    Replies: 0
    Last Post: 06-03-2011, 09:51 AM
  2. Calculating Elapsed Time
    By jo15765 in forum Forms
    Replies: 8
    Last Post: 04-15-2011, 07:00 PM
  3. Expression builder
    By PJ_d_DJ in forum Access
    Replies: 2
    Last Post: 02-24-2011, 03:38 AM
  4. Time Elapsed Problem
    By leejqs in forum Reports
    Replies: 6
    Last Post: 07-16-2009, 07:58 AM
  5. Expression Builder
    By mistaken_myst in forum Access
    Replies: 2
    Last Post: 05-07-2008, 01:30 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