Question

Sharpie44

New member
Local time
Today, 13:57
Joined
Nov 22, 2008
Messages
1
I have an access problem for my B.I.S class. I'm almost finished with the data base but I'm having problems with one Querie. I need to create a querie that has a field that gives the most requested Person. I need the output fieald to say the numder of times the person has been requested next to the rest of the info. I can't remember how to derive that from the list. I know it involves using the Persons ID number from one sheet.
 
Well u could create an aggregate query with just personID and Requests and group by Count on Requests. Run a DMax query on Requests in this query.

HTH
 

Users who are viewing this thread

Back
Top Bottom