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

Can anyone see a problem with this expression

Status
Not open for further replies.
justlearning2003

justlearning2003

Technical User
May 26, 2003
34
CA
Hey,

Just wondering if anyone can notice a problem with this expression. I am getting an aggregate function error.

Expr2: Sum([tblstj]![acd_calls]) / [tblstj]![acd_calls]

Thanks
 
Sort by date Sort by votes
Untested, but would guess:

Expr2: Sum([tblstj]![acd_calls]) / Sum([tblstj]![acd_calls])

and make sure the Total is "Expression"

Bill
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
3K
dhookom
dhookom
BJZeak
  • Locked
  • Question
Struggling with finding an answer to a simple question
Replies
5
Views
729
BJZeak
BJZeak
TrekBiker
  • Locked
  • Question
This is the source query for what 1
Replies
12
Views
658
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
835
TrekBiker
TrekBiker
TheresAlwaysAWay
  • Locked
  • Question
"There isn't enough memory to perform this operation..." error after upgrading from Access
Replies
2
Views
460
Axworthy
Axworthy

Part and Inventory Search

Sponsor

Back
Top