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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count Problem

Status
Not open for further replies.
Silvinho

Silvinho

Programmer
Jul 9, 2001
58
GB
I have a recordset that selects various records and has a Column [Quantity] * [Price] AS Total_Price.

The problem i have is i want to get the SUM of the whole Column of Total_Price.

Is this possible and if so how?
 
Sort by date Sort by votes
Sum([Quantity] * [Price]) should do it, but this will return a single row is this what you want?



William
Software Engineer
ICQ No. 56047340
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Problem: sql-Select with request.form
2
Replies
22
Views
495
leifoet
leifoet
leifoet
  • Locked
  • Question
How to log in without a popup problem?
Replies
3
Views
176
ggriffit
ggriffit
ZeeHashmi
  • Locked
  • Question
ASP : Email Body UTF-8 Problem
Replies
3
Views
377
ZeeHashmi
ZeeHashmi
leifoet
  • Locked
  • Question
Problem with updating database reords.
2
Replies
31
Views
512
leifoet
leifoet
leifoet
  • Locked
  • Question
Convert Word text with images to html (problems)
Replies
1
Views
181
leifoet
leifoet

Part and Inventory Search

Sponsor

Back
Top