Access Query Question

[mark1]

I'm pretty new to Access, but old to SQL, so I can follow
what's going on. My quesion: Is there a way to sum a
field in Access using a condition on a field that I don't
want in my output. In SQL it's:

Select sum(dollars) as Dollars
From Table1
Where Region = '001'

Here, Region 001 dollars are summed, but the region isn't
displayed.

 

[Guest]

Please post in the Access Forum - not Excel