DCount Items in query field

[rdr910]

Need a little help - I have made a report that gets its information from a query that gets its results from a form search. I use the following code to get the total number of records that the search brings up: =DCount("*","[mainquery]") using a text box on the report. This does work perfectly. Now I want to get the results from a field for a count of certain items and have it appear in a text box on the report. I am using the following code but gives an error: =DCount("TS","[mainquery]","[OVERALLSATISFACTION]") - I am trying to find all items that are "TS" in that field and have that number returned to the text box on the report.

Someone please help!

[orange]

See this for proper syntax of Dcount
http://www.techonthenet.com/access/f...ain/dcount.php

[rdr910]

i am getting an error when i try to run this from a report. DCount("*", "mainquery", "SatDriver = TS")

using * as the expression to count all records. Mainquery is the query and SatDriver is the field i am trying to get the count of "TS" from.

What am I doing wrong?

[orange]

Don't see anything obvious.

Try
DCount("*", "mainquery", "SatDriver = 'TS'") if SatDriver is a text value

[rdr910]

That worked! Thanks! One last question, how would i find the "null" values with using the code above?

[orange]

Try

DCount("*", "mainquery", "IsNull(SatDriver)")

[rdr910]

The code is giving me an error

[orange]

What is the error message?

Try
DCount("*", "mainquery", "SatDriver Is Null") Is Null is the sql statement expected by DCount

IsNull() is a vba function which is not used or expected with DCount or other aggregate functions.

Sorry for any inconvenience.