Ability to alter data before preview of Report

[J. Trucking]

Hello,

I am building a report (through a query) but I would like to give the
user the ability to change the data before the report opens. So, for
example, lets say I want to bring up some hours worked for various
employees in a given time span (let's say one month). Each employee
is tied to a charge out rate.

When the user enters in the time span on a form and clicks preview,
the query will gather the results (the employee's name, the hours
worked within the time span, and their specific charge out rate) and
what I am hoping is that I can display these results in some sort of
table where the user could say, alter the charge out rate. Then, once
they have changed the data to their liking, they hit a button which
creates the report.

Hopefully I have explained this well enough. Any advice or
information would be greatly appreciated.

Thanks in advance,

John

 

[Tom van Stiphout]

On Thu, 1 May 2008 21:28:18 -0700 (PDT), "J. Trucking"

The simplest solution is to first copy your data to a "temp" table,
then show the data for the user to modify, then use the temp table as
your report's data source.
If you actually want to save the edits permanently, the scenario is a
bit different and you may just want to create a datasheet view on the
real tables and have the user make any edits necessary before clicking
the Preview Report button.

-Tom.

 

[J. Trucking]

Hi Tom,

Thanks for the response. The temp table would be perfect. Is there a
special way to create a temp table or would I just create a regular
table?

Thanks,

John

 

[Tom van Stiphout]

On Fri, 2 May 2008 07:01:30 -0700 (PDT), "J. Trucking"

It's a regular table. It's only temporary in the way you think about
the data it holds.
You would write a Delete query to clear out all previous data, then an
Append query to add the new data.

-Tom.

 

[Douglas J. Steele]

To avoid problems with database bloating, you might want to put the
temporary table in a temporary database.

Tony Toews has an example at http://www.granite.ab.ca/access/temptables.htm