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

DCount Problem 1

Status
Not open for further replies.
FontanaS

FontanaS

Programmer
May 1, 2001
357
US
Hi,

I have the following function in a text box on my report.

=DCount([A1],"Qry_Questionnare",[A1]=0)


I keep getting the #error when I try to view it. The Field [A1] is a number field.

Any suggestions ?

THANKS!
 
Sort by date Sort by votes
You need quotes around all of the arguments. Try:
Code: 
=DCount("[A1]","Qry_Questionnare","[A1]=0")

Hoc nomen meum verum non est.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

soloracer
  • Locked
  • Question
Problem using report recordsource values within report events. Error 2427 1
Replies
17
Views
408
soloracer
soloracer
Kennelbloke
  • Locked
  • Question
Problems with image on report 1
Replies
8
Views
288
dhookom
dhookom
Triacona
  • Locked
  • Question
Dcount issues
Replies
3
Views
120
Triacona
Triacona
lameid
  • Locked
  • Question
The Never shrinking whitespace problem 1
Replies
6
Views
183
lameid
lameid
Lhuffst
  • Locked
  • Question
problem passing dates
Replies
2
Views
118
Lhuffst
Lhuffst

Part and Inventory Search

Sponsor

Back
Top