Date format in Tables

  • Thread starter Thread starter davespace
  • Start date Start date
D

davespace

I have two seperate records in a table: Month (mm) and
Year (yyyy)

Is there a way to format/update these seperate records
using current Month and Year as individual data? I am
required to provide this information on a monthly basis
and creating and/or editing an Update Query every 4 weeks
is tedious (and likely not the most efficient way of
achieving the desired results). Currently I have the
records Default Value set to "01" and "2004" respectively
for each field so that when I perform my Append Query it
populates the cell with is Default Value, but when 02
(February) rolls around I will have to edit the records
Default Value to reflect the new month. I hope this makes
sense...TIA

David
 
I'm confused. Do you have two fields or two records? The current month is
always Month(Date()) and the current Year is always Year(Date()).
 
I have two seperate records in a table: Month (mm) and
Year (yyyy)

Is there a way to format/update these seperate records
using current Month and Year as individual data? I am
required to provide this information on a monthly basis
and creating and/or editing an Update Query every 4 weeks
is tedious (and likely not the most efficient way of
achieving the desired results). Currently I have the
records Default Value set to "01" and "2004" respectively
for each field so that when I perform my Append Query it
populates the cell with is Default Value, but when 02
(February) rolls around I will have to edit the records
Default Value to reflect the new month. I hope this makes
sense...TIA

David
Click to expand...

Set the Default properties of the fields to

Format(Date(), "mm")
and
Format(Date(), "yyyy")

respectively.
 
Back
Top