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!

#Error

Status
Not open for further replies.
ptrifile

ptrifile

Technical User
Aug 10, 2004
457
US
I am totaling a field from a query based on a count, however if there is nothing for that particular item the report shows the following:

Textfield #error

I would like it to show

Textfield 0

Is there something i can do to achieve this?

Thanks in advance!

Paul
 
Sort by date Sort by votes
I figured this out. Used the following:

=IIf([HasData],Count([myfield]),0)
 
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
385
soloracer
soloracer
JoPaBC
  • Locked
  • Question
Rounding error
Replies
4
Views
160
JoPaBC
JoPaBC
Triacona
  • Locked
  • Question
run-time error 2585 - action can't be carried out - while using DoCmd.SendObject acSendReport 1
Replies
17
Views
409
Triacona
Triacona
monkeysee
  • Locked
  • Question
Syntex Error (missing operator) in query expression
Replies
5
Views
160
dhookom
dhookom
JimStrand
  • Locked
  • Question
DoCmd.SendObject Compile Error - Sub Or function Not Defined 1
Replies
5
Views
199
JimStrand
JimStrand

Part and Inventory Search

Sponsor

Back
Top