DSum Question!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following dsum statement on my report but am getting an error on
my report and am not sure why.

Its supposed to count CRqsts if expr1 is c<48 for each employee!

DSum("[CRqsts]","qryTrack","[expr1] ='" & "c<48" & "And [EmpID] =" & [EmpID])
 
Try

=DSum("[CRqsts]","qryTrack","[expr1] ='c<48' And [EmpID] =" & [EmpID])

And if the [EmpID] is string type field

=DSum("[CRqsts]","qryTrack","[expr1] ='c<48' And [EmpID] ='" & [EmpID] & "'")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change to report code needed 3
DSum Countrol Source Help 5
Dsum Issues 0
DSum Problem 4
Date overlap***UP*** 1
Relationship query 3
Access Need help with Simple HR Form in Access 2007 0
Using Bound Control right 3

Back
Top