Please Help me.. If I don't do this withing 4 hours from now or i'll die

[Locomotive]

I have 4 hours left to submit my work in access.. which is a 1.5 pt course required to continue.. I should have done it 2 days ago but I asked for another 2 days from the professor.

Okay so all of people who really use access should probably now it... I have 3 tables:
- Drivers - License #, Name, Adress, Date of License, Birthday.
- Fines - No#, Code, Date, Hour, Place, No. of Policement
- Fine Description: Code, Type, Charge...

There are a lot of things to do there, most of them I done. but I don't now this:

1. "Make a query that will show drivers who have more than 3 fines".
2. "Drivers between the age of 25-35 with 0 fines"
3. "Total amount of fines per driver".

So basicaly I don't understand how to relate and count fines per driver! Because those are two different tables, and even if you try to put them in the query you see:

"John Doe ...." 25$
"John Doe ...." 25$
"John Doe ...." 25$
"Baba Sali" 10$

But I do no need to see this - I need it to be:
"John Doe ... 3" 75$
"Baba Sali - 1"10$

Please guys this is urgent! it's 10:00 now and need to know this by 15:00 or they'll probably kick me from the university for missing so much...

 

[Rich]

http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=153330#post153330