DCount syntax problem?

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

Guest

It seems like this should work...

=DCount("[DevNum]","qry_Deviations","[StudyType] = ' " &
[Forms]![frm_Reports]![lst_Group])

Any thoughts?
 
If the field StudyType is a string then you need to add another single quote
in the end, and remove the space between the single quote and the double quote

=DCount("[DevNum]","qry_Deviations","[StudyType] = '" &
[Forms]![frm_Reports]![lst_Group] & "'")

If its a number, the remove the single quote from it
=DCount("[DevNum]","qry_Deviations","[StudyType] = " &
[Forms]![frm_Reports]![lst_Group])
 
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

Access Dcount (multiple criteria) 3
Access Dcount function in access 0
Dcount the values 0
SQL Criteria for report 3
DCount between dates 4
DCount Error 6
access report DCount function 4
Access MS Access DCount function problem 0

Back
Top