Criteria based on a date results in a specific value

[macattack03]

I don't know what it would be called or even how to start doing it in access other than it requires a criteria here is what I'm trying to make happen with access

name date yes/no criteria would be set to date > 180 days then it would equal value of No < 180 days then equal value Yes



If i set a today's date value on the database and then criteria is based of the value in the date box with the above information how would this be done

I'm really lost with this guys please help if anyone can understand what I'm trying to do

[macattack03]

after a little bit more reading and understanding of this guys its like a function i guess in excel except its called a IIF here please assist this is what i came up with off of the examples

IIf([APFT date]<180,[APFT VALID] ="yes",IIf([APFT date] >180,[apft valid] "no")

The valid is a yes/no criteria with a check box and the date is the criteria it is checking whether its greater than 180 days or less than

Does this make sense to anyone?

[NTC]

IIf([APFT date]<180,[APFT VALID] ="yes",[apft valid]= "no")

if the criteria is met [APFT date]<180
then: [APFT VALID] ="yes"
else: [apft valid]= "no"

the IIF syntax simply uses the comma symbol instead of the then/else keywords

[macattack03]

I copied the top IIF command and pasted it in the criteria box in my query however its not working its giving me an error

Data type mismatch in criteria expression

[NTC]

I just dealt with the syntax of an IIF and not the content..... data type mismatch is probably [APFT date]<180 if indeed that is a date field then such a compare doesn't make sense; perhaps: [APFT date]<(Now()-180)