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

Extra paren issue?

Status
Not open for further replies.
Zonie32

Zonie32

Technical User
Jan 13, 2004
242
US
Expr10: IIf(IsNull([ACH_AccountChange]),0,[ACH_AccountChange])

saying there's an extra ) paren.??? help. thanks.
 
Sort by date Sort by votes
Why not posting the SQL code ?
Anyway, I'd use the Nz function instead.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

accesshelp1
  • Locked
  • Question
How can I remove parenthesis and everything that comes after it? 1
Replies
3
Views
937
Andrzejek
Andrzejek
Swi
  • Locked
  • Question
Performance Issue
Replies
4
Views
232
dhookom
dhookom
puforee
  • Locked
  • Question
Query update issue
Replies
5
Views
356
Andrzejek
Andrzejek
Cpreston
  • Locked
  • Question
Update field Issue 1
Replies
3
Views
207
Andrzejek
Andrzejek
RanaH
  • Locked
  • Question
Issues with sorting combo box on form
Replies
1
Views
260
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top