Help using IIF statement calculated column through Linked Table

[hellfire45]

So I have this If statement that goes something like this;

IIf {ttblEQAnswer_FCLIT.ActionType} = 'Answer Affir Defense' andnot isnull({ttblEQAnswer_FCLIT.METPrep}) and not isnull({ttblEQAnswer_FCLIT.AttyInstr}) and
({ttblEQAnswer_FCLIT.METPrep})> date(1900,1,1) and not isnull({ttblEQAnswer_FCLIT.AttyInstr})
and {ttblEQAnswer_FCLIT.METPrep} < currentdate - 10
then 'Y' as [MET InstructNeed?],

I want to use the above formula to calculate a column. However, do I need to join the tables referenced above in order to get this formula to work? As it stands I'm getting an error that says "Malformed GUID in query expression".



What am I missing here? Thank you for the attention.

[ranman256]

1st, the IIF does not use braces. Use help to see the layout. IIF(condition,true,false)
ANDNOT is not a valid operator.

2nd, since you have a complex IF, I would simplify by adding a field MET, then run a macro that has 2 queries....
Q1 to set MET to null
Q2 to update it to YES if all your fields are met. No IIF needed.

[orange]

Did you find these commands/functions somewhere???
{
date(1900,1,1)
andnot
currentdate

For syntax and sample usage of Access functions please see techonthenet.

I also recommend you review these debugging and error handling techniques by Chip Pearson. The sooner you learn these, the quicker you will become more independent.

[rpeare]

MET InstructNeed: IIf( ttblEQAnswer_FCLIT.ActionType = 'Answer Affir Defense' and not isnull(ttblEQAnswer_FCLIT.METPrep) and not isnull(ttblEQAnswer_FCLIT.AttyInstr) and
(ttblEQAnswer_FCLIT.METPrep)> #1/1/1900# and not isnull(ttblEQAnswer_FCLIT.AttyInstr)
and ttblEQAnswer_FCLIT.METPrep < date() - 10,"Y", null)