Counting Records in a Query

[bomich]

I have two tables, RMA Numbers and Serial Numbers. Each RMA number will have multiple serial numbers assosiated. I need to find a way to count how many serial numbers are assosiated with each RMA number.



I think the best way to do this is in a query using the dCount function some how.. but I can't figure out how to get it to count different serial numbers for the same RMA number.

I also considered writing my own function to do it.. but it got really messy and there must be an easier way to do it..!?

Any Ideas???

[alansidman]

What are the fields in each of the tables? Is there a common field that you can join the tables on and then perform an aggregate query?

[bomich]

Literally the whole of yesterday spent trying one thing after another!
I'd never heard of aggregate queries before so googled it first thing this morning..
had a quick go
works perfectly straight away..!
ahh.. the joys of databasing..! :L

Thanks Alan! (: