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

Help Building a specific expression

Status
Not open for further replies.
Setter00

Setter00

Technical User
Aug 9, 2001
3
US
I'm trying to build an expression that will calculate a total for me. Basically I need to find a $ amt for all items that meet a specific requirement. I did not build this DB so I'm having several problems! The expression I've been trying to make work is " =Sum[fldCAmtFiled]where([fldCStatus])=8 ". Does anyone have an idea that may work?
 
Sort by date Sort by votes
use Dsum()

= DSum("[fldCAmtFiled]", "YourTableName", "[fldCStatus] = 8")

PaulF
 
Upvote 0 Downvote
Thank you! It works better than what I had in mind!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
4K
Andrzejek
Andrzejek
MikeRei
  • Locked
  • Question
Help taking horizontal data and displaying it vertically (continuously)
2
Replies
27
Views
1K
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
3K
TheresAlwaysAWay
TheresAlwaysAWay
atadbitslow
  • Locked
  • Question
need help with syntax for a date
Replies
3
Views
238
dhookom
dhookom
A
  • Question
Print Table attachment
Replies
2
Views
131
andre.meyer
A

Part and Inventory Search

Sponsor

Back
Top