Add 2005 Dates to a Table

B

Bruum

I have a table that I need to add Mar to Dec 05 records to for each employee
- a hideously long manual task. I can't figure out how I can do this
automatically - presume an Update or Append Query would work???

The reason for this is my reports for the new year are only printing Jan and
Feb data and most of them (as they are graphs) require entries of data for
March through to December.

Please let me know what further info you require to help me - we have 1000's
of employees and don't want to manually enter Mar - Dec date fields in the
table for each one if it can be avoided.

Thanking you in advance (I am a basic user so layman's terms would be great
:))
 
S

Steve Schapel

Bruum,

You can make a table with one field, Date/Time data type, and enter your
dates in there. Probably won't take too long manually, but you could
speed this up by putting the dates in Excel, and using its AutoFill
feature to complete the listing, and then importing this into an Access
table. Ok, then make a query, which includes your Employees table and
this Dates table. Do not join the tables, but put the EmployeeID field
(or whatever you call it) from the Employees table, and the YourDate
field from the Dates table, into the query design grid. This query
should return a record for every date for every employee. Then you can
make this into an Append Query (select Append from the Query menu),
nominate the table you need this data added to (making sure you have a
backup of your database first), and run the query to do the job. Make
sense?
 
B

Bruum

Thanks so much Steve - I am sure this will work and yes it does make sense.
Thanks for your very quick response. I will try it out tomorrow and let you
know how it goes :)
 
B

Bruum

Hi Steve

I know its one month later but I had to leave this alone and get on with
other work - have just done what you said, and apart from a few minor
glitches I figured out (I needed to name my dates field the same as the table
field, and I needed to add the Branch No) it worked great - my graphs are
printing superb this month - thank you so much for your help :)
 
Top