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!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Selection formula question 1

Status
Not open for further replies.

ribbons

Technical User
Apr 26, 2007
113
US
Hi,

I am creating a front end in vb.net 2005 to open a CR. I need the selection formula to read something like this:
Code:
Dim selectionFormula As String = "{GermReadings.TZAmountPaid}= '0'"

This throws an error that reads:
Code:
A number is required here

I've tried every sort of combination I can think of and I think the problem is in the formatting of the value after the "=", but I can't seem to hit on the right combination. In the DB(MS Access), this value is stored as a number(0 or 5) and the field is defined to be a number.

Any ideas?

ribbons
 
Get rid of the single quotes around the zero.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"What version of URGENT!!! are you using?
 
That worked! Boy, I'm always amazed at the "laying on of hands" ability you guys have! I would swear I'd tried that and it didn't work!

Thanks so much and here's a star!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top