Am hoping someone can help me figure out how to do this. I have a simple DB for tracking of hours for our Contract Labor usage.
The fields are:
I am trying to figure out a way to get Calendar Year to default to the Current year. I've tried using Year([EntryDate]) but it doesn't recognize the field name. Is there something else I can do to get this field to default automatically instead of me having to go in and change the Default Value Every year?
In that case you have a transitive dependency and are violating third normal form.
Don't store this data - just derive the year as and when you need it. It is for the same reason you only store date of birth and work out age as and when you need it.
This is not VB - this is SQL.
"this, that" were made up column names - just placeholders, you would use real column names.
SQL is the code that is "behind the covers" when you create a query. Really, Access is just translating the actions you make in the query designer into (horribly formatted) SQL. Look at your queries in "SQL View" to see what I mean.
No - you do not have a column in your table for the year of entry. You derive the year of entry from the Entry Date whenever you need it. You do not store the year separate to Entry Date.
The reason is that there is a functional dependency between Entry Year and Entry Date.