Date format in Tables

[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

 

[Duane Hookom]

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()).

 

[John Vinson]

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

Set the Default properties of the fields to

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

respectively.

 

[John Nurick]

Hi David,

Set the default values to Month(Date()) and Year(Date())