expressionbuilder - Microsoft Access - query checkbox based on textbox -
i have field text field containing dates. have checkbox named "delivered" if text field contains date, "delivered" checkbox value "true" / ticked. if text field isnull, checkbox value must "false" / not ticked i have tried following in query expression builder of checkbox: iif([datefield]="";false;true) but keep getting error expression being built incorrectly? you trying store calculation/dependent value in table based on field in same table, not advisable , should not carried forward. calculations should done when , required, display on forms, query export or reports show. more info on calculation field available here : http://allenbrowne.com/casu-14.html if want can create update query as, update tablename set deliveredfieldname = iif(len(datefieldname & '') = 0, false, true);