There were two authors that had "Salt Lake City" in the CITY field.
Now that field holds "Olympic Lake City" for those two authors.
Microsoft Access date functions are a powerful way to retrieve and analyze data in your Access databases, but very few users know about these functions or how to use them.
Following this example, let's say we would like to automate the date for when a case is received.
Once this property is set for your field, users can skip past this field when doing data entry or modify the date as necessary.
The Date Part function looks like this: Date Part(«interval», «date», «firstdayofweek», «firstweekofyear») Interval is a required string expression representing the interval of time you want returned.
Date is another required variant representing the value or date you want to evaluate.