Can Access Perform Calculations?

[kpschroeder]

I have logon and logoff scripts I run on users where the results are
sent to a text file which looks like this:

User MKEARCLAP02\Processor logged on computer MKEARCLAP02 8/11/2006
1:51:57 PM
User MKEARCLAP02\Processor logged off computer MKEARCLAP02 8/11/2006
1:53:28 PM
User MKEARCGX150\Processor logged on computer MKEARCGX150 8/11/2006
1:53:30 PM
User MKEARCGX150\Processor logged off computer MKEARCGX150 8/11/2006
1:56:07 PM
User MKEARCLAP02\Processor logged on computer MKEARCLAP02 8/11/2006
1:56:07 PM
User MKEARCLAP02\Processor logged off computer MKEARCLAP02 8/11/2006
1:59:07 PM
User MKEARCGX150\Processor logged on computer MKEARCGX150 8/11/2006
1:59:09 PM
User MKEARCGX150\Processor logged off computer MKEARCGX150 8/11/2006
2:17:58 PM
User MKEARCGX150\Processor logged on computer MKEARCGX150 8/11/2006
2:21:21 PM
User MKEARCGX150\Processor logged off computer MKEARCGX150 8/11/2006
2:21:34 PM
User MKEARCLAP02\Processor logged on computer MKEARCLAP02 8/11/2006
2:21:58 PM
User MKEARCLAP02\Processor logged off computer MKEARCLAP02 8/11/2006
2:22:35 PM
User MKEARCGX150\Processor logged off computer MKEARCGX150 8/11/2006
2:24:21 PM
User MKEARCGX150\Processor logged on computer MKEARCGX150 8/11/2006
2:24:44 PM
User MKEARCGX150\Processor logged off computer MKEARCGX150 8/11/2006
2:24:55 PM
User MKEARCLAP02\Processor logged off computer MKEARCLAP02 8/11/2006
2:27:02 PM
User MKEARCGX150\Processor logged off computer MKEARCGX150 8/11/2006
2:28:29 PM

From here I import these results into excel which looks like this:

MKEARCLAP02\Processor on MKEARCLAP02 8/11/2006 13:51:57
MKEARCLAP02\Processor off MKEARCLAP02 8/11/2006 13:53:28
MKEARCGX150\Processor on MKEARCGX150 8/11/2006 13:53:30
MKEARCGX150\Processor off MKEARCGX150 8/11/2006 13:56:07
MKEARCLAP02\Processor on MKEARCLAP02 8/11/2006 13:56:07
MKEARCLAP02\Processor off MKEARCLAP02 8/11/2006 13:59:07
MKEARCGX150\Processor on MKEARCGX150 8/11/2006 13:59:09
MKEARCGX150\Processor off MKEARCGX150 8/11/2006 14:17:58
MKEARCGX150\Processor on MKEARCGX150 8/11/2006 14:21:21
MKEARCGX150\Processor off MKEARCGX150 8/11/2006 14:21:34
MKEARCLAP02\Processor on MKEARCLAP02 8/11/2006 14:21:58
MKEARCLAP02\Processor off MKEARCLAP02 8/11/2006 14:22:35
MKEARCGX150\Processor off MKEARCGX150 8/11/2006 14:24:21
MKEARCGX150\Processor on MKEARCGX150 8/11/2006 14:24:44
MKEARCGX150\Processor off MKEARCGX150 8/11/2006 14:24:55
MKEARCLAP02\Processor off MKEARCLAP02 8/11/2006 14:27:02
MKEARCGX150\Processor off MKEARCGX150 8/11/2006 14:28:29

What I would like to is calculate the number of times a user logs in
and out and also the total time the user was logged in and total time
the user was logged out.

I know I can manipulate this data in excel, play around with formulas
and come up with the answer however, management is requesting a more
user friendly way to search, hence the database.

Is it possible to take this formatted data from excel into access and
have access calculate my logon, logoffs and the total time logged in
and total lime logged out?

 

[Dave F]

Well you have to build an appropriate query, and in the query design, build
the appropriate calculations. Calculations in Access are somewhat similar to
Excel, but there are definite differences. I'd look in the help file for
building queries, specifcally, performing calculations with them.

Example: Expr1:Count(*) would count all the rows in a table or query.

Dave