[AccessD] total of sum

Hello,

sometimes when have asked a question and see the responce, you can find yourself a compleet idiot. Why the hell did i ask this??
Sometimes your so busy with other work, that you don't take the time to think. I would do this with select distinct, i don't know why. I didn't thought on group by, and why am i not looking in the design view?

But thanks to all who responded.

Pedro Janssen
Cytologist





From: rsmethurst at UK.EY.COM
To: Access Developers discussion and problem solving
Date: Thu, 25 Mar 2004 12:48:13 +0000
Subject: Re: [AccessD] total of sum

Hi Pedro,

In your query, you want to Group By on the first field and then Sum the 
second field.

Ryan