JStrittmatter
Technical User
I have 2 queries one sums the total cost of services vended to a consumer by service the other sums the total receivibles for a consumer by service.
I want to create one query that will show me for each consumer that will show me the sum of service and the sum of receivibles by service.
Results example
ID# LastName FirstName Service SUMofService SUMofRec.
22 Doe John ADC $250
23 Doe Jane PC $500 $450
If anyone could help me soon I would love it.
thanks
Justin
I want to create one query that will show me for each consumer that will show me the sum of service and the sum of receivibles by service.
Results example
ID# LastName FirstName Service SUMofService SUMofRec.
22 Doe John ADC $250
23 Doe Jane PC $500 $450
If anyone could help me soon I would love it.
thanks
Justin