Selection formula question 1

[ribbons]

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:

Dim selectionFormula As String = "{GermReadings.TZAmountPaid}= '0'"

This throws an error that reads:

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

 

[dgillz]

Get rid of the single quotes around the zero.

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

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[ribbons]

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!