Microsoft speak for If/Then???

[Microbabble]

I'm trying to get Access to look at a field, compare it to a text if the field is a certain text value then update another field with the output I want. I think the problem is in my syntax but my knowledge base is very limited.

I am trying to do this using a macro (set value command).

=IIf([TYear]= FY, [Cut Off] "30 SEP", [Cut Off] "31 DEC&quot

any help would be appreciated.

 

[braindead2]

I would think if you just put this as the default value in the cutoff field it would work

=IIf([TYear]= FY, "30 SEP", "31 DEC&quot

again this is said with me assuming a lot of things.
good luck

 

[Microbabble]

I tried your suggestion and it worked on the form. Unfortunately, it doesn't seem to update the table. So I am back to attempting to write a macro. I know this should be stupid simple but nothing I have tried has worked. There is another problem I would like it to check for data in another field (Accumulation Year)if data is present then update the the (Cut Off) field based on what is present in the (Type Year) field.

Thanks Again!