I have to create this database using MS Access but not sure what this rule means. My assignment requires this rule(one of many) to be implemented in my database when I create a table.
"The date a transaction takes place must default to the computer's current system date".
I've entered a validation rule which allows only the current date to be entered but now I can't enter any of my data because the dates are in the past.|||Don't use validation. When designing your table, against the "Default Value" property, put
Date()
This means that when you create a new record, Access assigns today's date, but you can overwrite it.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment