Report Populating a Table

[lansel]

I have a report created from various queries that creates a disciplinary notice for attendance. The report lists the various dates and information that led up to the improvement notice and the Level of the notice. Most of the information in in column format except for the level of notice and that information is at the top of the report.

Now, management wants me to have the information toautomatically populate the employee's history table, which is in another database. I have linked to this table before and poplulated it but it was by a form.

How do you populate a table from a report?

Of course, they expect me to have it done today? HA

Thanks,

 

[llkhoutx]

Use the recordsource for the report in a make table query.

 

[lansel]

Well I did the Make-Table Query from the same query I created the report, but how do I get the information from the report to the table to the other table? I am not real experienced with Access, so please give me a hint.

Thanks

 

[llkhoutx]

View the record source for your report in a query. Then make that query a make table query.

 

[lansel]

Well, I am still working on the same stuff. I ended up creating a append query that duplicates the information in the Improvement Notice Report to a table. From the Table I created the employee history report. Thanks for all your help in accomplishing that part.

Now, I have a problem with the date. When I enter the information on the Improvement Notice Report, the date on the report is the current date. That is the date the IN was issued. This date needs to go to the table so it will be in the history report as the date the improvement notice was issued. The append query did not put a date field in the table. When I added one, I did not know how to have the date entered.

This is probably simple, but I can't figure it out.