Access Property sheet data missing also syntax

Joined
Aug 10, 2017
Messages
1
Reaction score
0
I am just beginning to learn Access and have two questions. I was trying to use a conditional expression in the default property of a date field on a form. Somehow I lost all the data in the property sheet. The sheet displays with all the captions but the data is gone. Just a blank space after the caption. The caption column is not even highlighted like it usually is. What happened or, more importantly, how do I get the information back. Secondly, what is wrong with this expression: "IFF (WEEKDAY()=1[WORK_DATE]=DATE()-2, [WORK_DATE]=DATE()-1)" I don't want to have to enter a date when I enter the previous workday's transactions. I get an error message in the data box when I open the form and try to enter a new record. I want the default date to be 2 days before today's date if it is now Sunday and yesterday's date if today is any other day of the week. I know nothing about SQL or VBA so hopefully someone can answer in simple Access terms. Thank you so much.
 

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

Top