iif statement using Access database

[sunmed]

Crystal Reports newbie.
Trying to set up an iif statement to work with an Access database. Believe I have the part "=...)" but cannot get it to check out. Am I missing a beginning? Am putting this in a formula and am lost!
TIA
Charlie

 

[kenhamady]

Are you in MS Access or are you in Crystal reading an Access table.

In Crystal you might find it easier to use Crystal's If Then Else syntax:

If {table.Gender} = "M"
then "Male"
else "Female"
Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[sunmed]

I'm in Crystal, what i need to do is from the data "refill 2 times" (part of a snippet) find the 2 and then print the 2. this figure is variable and sometimes isn't there . When it's null, i then have to print an "X" on a different line. Ken, do you ever teach in the Southern New England area?
I've learned to do some simple stuff with Crystal but now I have a need to work with Crystal (native) and Advantage (OBDC) to create 1 report. Man, that's way over my head.
Charlie

 

[kenhamady]

Sunmed,

You are searching a text field for ANY number or just 2, or a number after the word "refill"?
When you say null do you mean the entire field is null, or just that there isn't a number?

Questions about training should be off-line. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/