Results 1 to 3 of 3

Thread: Average Date and Time from a table[resolved]

Threaded View

  1. Apr 18th, 2005, 12:50 PM #1
    ustenmacduff
    ustenmacduff is offline

    Thread Starter
    New Member
    Join Date
    Mar 2005
    Posts
    5

    Average Date and Time from a table[resolved]

    Im having some problems with a Access Program Im writing. It consists of 4 fields in a table [ID][LogDate][logintime][logouttime]

    This program is for a login system for a computer lab. My problem is that I need to take the average minutes people are logged in, and use that as a running average. I then need to take than running average and use it to fill in any blank logout time fields at the end of the day.

    My main question is how to I take datedifference[logintime][logouttime] and capture it into a variable for later use.

    THanks.
    Last edited by ustenmacduff; Apr 18th, 2005 at 11:18 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width