Conditional Formatting or VBA for Report Fields

[GoldenOrb]

Hi, pretty new to this stuff but come unstuck with the below.

I am running a database/ rostering system for +30 staff over a fortnight running 24hrs a day, 7 days a week.
Now against each person there is 2 fields
Field 1) type of shift (Shift1 type) if Day, Arvo, Eve, Night + a couple of leave options... AL, LSL and or WL
Field 2) Start time (Shift1 time) ie 0700, 1500, 1700, 2100.... Now when it is one of the leave options the field in the record is left blank (currently a Date/time field)

What I want to achieve is when that field 1) displays "WL" field 2 is blank and I want it to input a "X" into field 2) whether it it via a expression through conditional formatting or vba



Is it possible to achieve this or am I dreaming

Thanks

Geoff

[pbaldy]

Try

=IIf(Field1 = "WL", "X", Field1)

[GoldenOrb]

Hi Paul, tried the above and unfortunately it didn't work. Thanks though

[June7]

Saving a calculated result requires code.

Can't save an "X" into a date/time field. X is text, date/time is a type of number field.

You can calculate the "X" to display on report if conditions met.