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!

Sum on Report

Status
Not open for further replies.
naiku

naiku

Technical User
Apr 25, 2002
346
US
I am trying to get a sum on a report, but cannot get it to work. I have an unbound text box with the following control source:
=DSum("[Cost]","tblJobItemsA","[JobID] = '" & [txtJobID] & "'" And "[SupplierID] = '" & [Supplier] & "'")

However, at the moment the criteria for supplier is not working. So I end up with the sum of costs for all suppliers, am I missing something on my above Dsum? Thanks.
 
Sort by date Sort by votes
Fixed using a query and Dlookup. Also found out that I had extra double quotes around the AND part of the DSum.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
511
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Open Report based on selection from a pull-down menu 1
Replies
12
Views
745
caykamanj1966
caykamanj1966
TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
486
dhookom
dhookom
SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
575
dhookom
dhookom
monkeysee
  • Locked
  • Question
Muti Page Report 1
Replies
5
Views
474
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top