Trasfer of Report Information to Database

  • Thread starter Thread starter Amish Patel
  • Start date Start date
A

Amish Patel

Can the information or data of a report in access be transfered to a
access database/table or querry. If yes, please help me how.
I am very new to access. I have prepared a report which sums up some
fields from a database. I now wish to store these totals of fields as
a table/database so that I can use them for some other purposes.

Regards
Amish
 
Your question is very confusing!

Data is stored in a table in a database. The data is entered on a form that is
based on the table or based on a query based on the table. A report is a
hardcopy output of data. A report is based on the table or based on a query
based on the table.
 
Thanks, I am aware of what you have explained. But I want to use
totals of certain fields in a table for further use. E.g. I have
records in a table which contains details of employee code, employee
name, monthly present days, hours worked, salary and various
allowances paid, statutory deductions made. And I have prepared a
report calculating yearly totals of above fields. I now require to use
these totals to calculate bonus, leave sal etc., to issue yearly sal
payment certificates and also store these yearly totals for future use
like calculating gratuity payments, etc. for the employees leaving the
organisation (say, after some years). I donot know how this has to be
done. Please guide me.

Regards
Amish Patel
 
Calculated values should not be stored. Each place you need the totals, you
should calculate them like you did in the report. If you are calculating the
totals in the report itself, you might consider calculating in a query instead
and then you can use that query in other places besides your report.
 
Typically it's not considered good practice to store calculated results.
However, it's possible. You need to make a separate Make-Table query to
store the summary results to a new table.

The preferred solution would be to create a query that would calculate the
summary totals in the same manner as your report, then use this query as the
source for further processing.
 
Back
Top