Developer Network >> Visual Basic Programming >> Crystal Reports

IF statement help

Hi, I have a Shift_ID field that i want to run an IF formula on that says

IF ({Field.A} = Odd Number) then "Days"
Else "Nights"

As you can probably tell i need it to show in my report the Night Shift or The Day Shift.

Probably easy for someone but i can easily be a buffoon and miss these things

Regards

Steve

[358 byte] By [snoopsterg] at [2007-11-20 10:54:16]

«« [RESOLVED] Cant seem to use my Public Sub.
»» Increasing speed to retrive the data from database

# 1 Re: IF statement help

Create a formula kind of this one:

if remainder({your_table.field},2)=1 then "Days" Else "Nights"

SvB_NY at 2007-11-9 14:11:28 >

# 2 Re: IF statement help

That worked like a dream Thank you

Steve

snoopsterg at 2007-11-9 14:12:28 >

Visual Basic Programming

All Classified

Visual Basic Programming New Topic

Visual Basic Programming Hot Topic