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

Please help!

Status
Not open for further replies.
sclark415

sclark415

Programmer
Mar 17, 2003
42
US
I have 2 fields. fieldA and fieldB. If fieldA = 111.11 or 112.11 then 0 else fieldA. Same as with fieldB - if 222.22 in fieldB the 0 else fieldB.


I know this is easy, but my mind has gone blank. Can you help me please?
 
Sort by date Sort by votes
Thanks anyways - I figured it out - I hate it when I get a momentary brain meltdown - thanks anyways!

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

john432
  • Locked
  • Question
Crystal Report Help 1
Replies
2
Views
340
john432
john432
BradCustom
  • Locked
  • Question
Need help with setting a value to 0
Replies
0
Views
176
BradCustom
BradCustom
chish_nc
  • Locked
  • Question
Need help getting oldest anniversary date to show
Replies
3
Views
277
pmax9999
pmax9999
kg2report
  • Locked
  • Question
Record Counter- please help 1
Replies
5
Views
169
lbass
lbass
Fermo Zolli
  • Locked
  • Question
Need help with formulas
Replies
1
Views
123
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top