Saving Records From A Report To A Table

[Eranka]

Hi

I am creating a report by searching an employee id in program. What i want now is when the report is created i want some of the reports content to save auto in a table that i have created. Is there is anyway to do it.

[orange]

Can you tell us a little more?
If you are creating a report based on a selected EmployeeID, where exactly is the other data coming from?
Sounds like it should be derived from tables related to Employee and specifically records related on that EmployeeID.
So it may already be in a table or two or three. You could use a query if you need specific fields.

[Eranka]

I have 4 tables

1.Employee Details
2.Rate Per Hour Details
3.Work Details
4.Payment Details

When i search a record using Employee ID the report shows with

1.Employee ID (Employee Table)
2.Employee Name (Employee Table)
3.Department Name (Work Table)
4.Time In (Payment Table)
5.Time Out (Payment Table)
6.Total Hours Worked (Time_out - Time_IN)
7.Total Payement ( Total Hours Worked * Rate) the rate comes from Rate table.

I want these above details to be saved in a another table automatically when i create the report. or is it possible to create a button to save above records to a table. Seeking Help

[orange]

That's not the normal/typical way of doing things. You would not store that data separately since it can be derived from existing tables. You would use a query.

Also, I would recommend you do NOT use a naming convention that allows embedded spaces. Sooner or later you'll encounter syntax errors.

Please post a jpg/png (screen capture) of your tables and relationships.

[June7]

It is possible but have to ask why duplicate data into a fifth table?

Since had to use a query to pull the data into report, makes no sense to save all that data to another table.

Is it because Rate could change and you want to preserve historical data? Just save the Rate into the PaymentDetails table. This should be done during data entry.

[Eranka]

The rate is not constant it changes once in every 3 months, if i save it onto a 5th table it will be easy for me to retrieve historical data.

[June7]

As I said, just save the rate with the original record during the original data entry process.