AutoFill or Paste into a new field in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populated a field 1
Create an input form 4
I want access to fill a field with the current date 4
DELETE FROM a table WHERE... 1
How to autofill in a table 6
How to Autofill a field based on a table of values 7
Track project FTE per year for five years in Access? 2
setting a default year in a table with multiple years 6

Back
Top