Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting the result of an aggregate function using DAO

Status
Not open for further replies.
xjs

xjs

Programmer
Apr 4, 2002
21
US
This seems to be an easy one but I can't find what I'm looking for. Can anyone provide the syntax to reference the result of an SQL statement that uses an aggregate function with DAO?

SELECT SUM(Cost) FROM table...

How do I reference or get the result of "SUM(Cost)" from this query.

Thanks.
 
Sort by date Sort by votes
i found the snytax i was looking for, thanks.

rs.Fields(0)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
348
Andrzejek
Andrzejek
M
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
413
SoftwareRT
SoftwareRT
Drago1920
  • Locked
  • Question
Finding the lowest date
Replies
2
Views
214
Andrzejek
Andrzejek
ziffer68
  • Locked
  • Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
313
ziffer68
ziffer68
Moss100
  • Locked
  • Question
Open New Access Database and Maximise the Application Window
Replies
0
Views
230
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top