Can Access Perform Calculations?

  • Thread starter Thread starter kpschroeder
  • Start date Start date
K

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:
Click to expand...

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?
 
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
 
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


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?
Click to expand...

Well you could do the whole thing in Access. Access should be able to
take your raw data and do the formatting that Excel is doing as well as the
number crunching you want.

The question is: do you want to spend the time and effort to lean enough
about access to automate the process.

Once it is set up properly importing the data and getting the answers
would be quick and easy and could have a very user friendly interface. How
well it works depends on who sets it up in Access and how well they do the
job.
 
Back
Top