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!

calculations in queries

Status
Not open for further replies.
kpryan

kpryan

Technical User
Aug 24, 2005
282
US
Hi all,
I have a continous form in which I want to sum a number column.
I want to do this in the query. How is this done please?

Many thanks

ken

 
Sort by date Sort by votes
The SQL of the query would be something like...
Code: 
SELECT Sum([TheRecordsouceOfYourForm].[YourField]) AS SumOfYourField
FROM TheRecordsouceOfYourForm;
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
230
PrimoSteve
PrimoSteve
Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
149
Xavierparkash
Xavierparkash
caykamanj1966
  • Locked
  • Question
Duplicate Records in DataSheet View
Replies
5
Views
259
Andrzejek
Andrzejek
StevenFromSouth
  • Locked
  • Question
Using .Fields() method in Recordsets for calculations. 1
Replies
1
Views
100
Andrzejek
Andrzejek
Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
904
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top