How can I append a table and set a date field to a specific date

  • Thread starter Thread starter JWCrosby
  • Start date Start date
J

JWCrosby

Not sure I worded the subject clearly, but here's what I'd like to do: I
want to append a table with 12 new records. Each record has a date field and
the new date field would be the first of the month, with all 12 months
represented. Here's what the appended records would look like (the Link
Field column represents the link to another table (arbitrary number used
here), since this is a one-to-many setup. I've also left out all the other
fields in the records.):

LinkField DateField
298 1/1/2008
298 2/1/2008
298 3/1/2008
298 4/1/2008
....
298 12/1/2008

The year would always be the same year for all 12 new records.

Jerry
 
I'm not sure I understand what having this data/table would allow you to do?

If you only need the first day of each month, you can generate/calculate
that 'on the fly' in a query, using the DateSerial() function.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top