Please Help

  • Thread starter Thread starter RichG
  • Start date Start date
R

RichG

Here's what my boss asked me to figure out.
We are a nationwide company with about 100 computers in
the field. We refer to the computers by the name of the
city they are in. Our department monitors a few of these
per day, so I made a database of diagnostic information
so we could predict issues based on certain criteria. My
boss would like a report that shows the most recent date
each computer has been monitored, computer name and
initials of the person who did the monitoring. That way
we know which computer to monitor next. It would help if
the report was sorted oldest to newest.
sample input from monitoring database table:

Computer name date monitored initials
------------- -------------- --------
Cleveland 1/1/04 gwb
Cleveland 1/25/04 jfk
Cleveland 2/1/04 djj
Detroit 1/5/04 jaw
Detroit 3/1/04 rmg

Desired output

Computer name date monitored initials
------------- -------------- --------
Cleveland 2/1/04 djj
Detroit 3/1/04 rmg

THANK YOU!!!
 
1) create a query with computer name and date monitored.
Change it to a totals query. Group by computer name and
select max for date monitored.

2) create another query - pull in first query and table
for input. Join table to query with computer name and
date monitored. This will get you the initials. Sort the
date monitored field ascending. This should give you what
you want.
 
Back
Top