Access MS Access IIF statement

T

themase

Joined
Jun 29, 2010
Messages
1
Reaction score
0
hello i am having a problem with an IIF statement

=IIf([yesno].[Value]="yes",[date]=Date(),[date]="")

i have a form called form1 and two fields one is a yesno tick box and the other is a date field

i would like the date to = todays date if the yesno box is ticked! any ideas!?!?!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access MS Access 2010 IIF statement to check if one date is in or out of range of two other dates (fields) 0
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Access Building a IIF expression in Access 0
Access Access database invalid syntax error message 0
Access Microsoft Access Calculated Field - Expiry Date 0
Access Validation rule in MS access 2010 1
Access IIF Statement - If field is greater than other field by =/-percentage 0
Updating the Form using the Yes/No 4

Top