M
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.
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.