AutoFill or Paste into a new field in a table

B

BarbL

I currently am working with an Access database that tracks worked hours.
Management has decided to add a Fiscal Year and a Period Field to the current
Hours table. Since we have over 50,000 data lines I do not want to copy
paste that many times. How can I get the table to fill in the data for the
current records. I will be able to manage maintaining later. The Period
field is set by a Financial close calendar and changes every year.
Thank you for your assistance
 
K

KARL DEWEY

Build a lookup table like --
Period FY StartDate EndDate
4 04 7/1/03 6/30/04
5 05 7/1/04 6/30/05

Add the Period & FY fields in YourTable.

Run an update query on YourTable like --
FIELD Period FY
ActionDate
UPDATE TO [LookUp].[Period] [LookUp].[FY]
CRITERIA Between
[LookUp].[StartDate] and [Lookup].[EndDate]
 
Top