As it turns out, I have come across another field in my table that relates to my previous question(s). In this case I have a field "Report Month" and I would like to set the default value to the current month but in the form (YY)_Month
In other words if I input a new record today, I want the default value to be: (06)_January
I know that when I learn VB
scripts this will probably be much easier but is there a way to do this with the built in functions in the Access library?