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

Summing field based on data entered by user

Status
Not open for further replies.
jwn625

jwn625

MIS
Sep 14, 2004
6
US
I have a query selecting records based on a predetermined join date. I'd like to sum amounts based upon a transaction date entered by the user. How can I do this?
Thanks,
jwn625
 
Sort by date Sort by votes
Create a query that accepts a date as a parameter.

SELECT MyDate, Sum(ValuesToBeSummed) As MySum FROM
tblYourTable
GROUP BY MyDate, ValuesToBeSummed



---------------------
scking@arinc.com
---------------------
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question
Delete Data from Field
Replies
1
Views
241
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
554
dhookom
dhookom
applestoapples
  • Locked
  • Question
Create duplicate rows based on Qty field
Replies
7
Views
256
Andrzejek
Andrzejek
TechieJr
  • Locked
  • Question
Filtering for null or empty field
Replies
8
Views
873
dhookom
dhookom
MattGreer
  • Locked
  • Question
Add Field Description to a Form 2
Replies
5
Views
350
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top