Hi Andy,

You didn't give us any idea of how much data, in terms of the number of
fields, you are changing. That information can make a difference ... You
can write some code to get done what you want but the cost/benefit ratio is
something you'd have to decide. If you've never done it before, I suggest
you try the following on at least one field:

In all cases, you'll create new field names in the QBE grid and follow them
with colons. If the change can be made with a fairly simple formula then
do something like: MyNewFieldResult: =(OldField1*3.14) . If there is a lot
of conditional code and complex calculation involved then write a function
procedure in the report module. and call it as follows; MyNewFieldResult:
=MyNewFunction(Field1). MyNewFunction will be written to return the correct
result.

The report must refer to your new field names rather than to the fields they
replace.

HTH
--
-Larry-
--

"Andy" wrote in message
...
I want to take data from a table, modify it and put it in
a report without changing the original table data.
OpenTable links the rst to the table data as does .clone.
OpenSnapshot locks the records for modification. I ended
up using a temp table, but this isn't very elegant. How
can I create a modifiable copy of a recordset independent
of the original?