Monday, December 12, 2011

Question about creating a DB in MS Access: What would this rule mean?

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.

No comments:

Post a Comment