if statement

[ddskorupski]

I have a documents table with a date field titled "datereceived".

I have a second table with a checkbox field that indicates if the document has been received. (we need to track these metrics)

I need an if statment that says if date received is null, then no in checkbox field, else yes.

How should that look?

 

[ajetrumpet]

You do this kind of stuff on forms, not in tables.the oncurrent() event would work best here.

 

[ddskorupski]

thank you. I apologize for not providing enough info. I actually want to build the if statment in an append query. Can you help me with that?

 

[honda882000]

Have you tried: IIF(IsNull(datereceived),No,Yes).

 

[ddskorupski]

thank you for your response. I just tried it and it is asking me to enter a parameter value

 

[ddskorupski]

ok. I figured out why it was prompting me for a parameter value. Now it is returning a -1 though. Any thoughts?

 

[MSAccessRookie]

ok. I figured out why it was prompting me for a parameter value. Now it is returning a -1 though. Any thoughts?

Under normal circumstances, -1=Yes/True, and 0=No/False. Is the Field a Number DataType instead of Yes/No?

 

[ddskorupski]

never mind..figured that one out too. Thanks all of you for your help. This site is awesome

 

[ajetrumpet]

This site is awesome

I have sometimes thought the same thing myself, although I don't participate much anymore.