I am looking for a little help with queries, I will write a simpified version of what I am trying to do.
tblCustomers (Fields: ID, LastName, FirstName)
tblHardware (Fields: ID, HWName, NetworkID, CustomerID, Quantity)
tblNetworks (Fields: ID, Name)
So basically a customer can assigned multiple hardware types for multiple networks.
When I run the query I get a list of the users with the above fields (repeated multiple times for each hardware). Instead I'd like the query to list each customer once, and then have count/sum columns for each piece of hardware for each network?
How tricky is this? I am trying to get the query perfect so I can easily export to excel for reporting purposes.
Thanks guys,