Passing Report Data to a Table

[martinw]

Can data in a report be passed onto a data entry form?

I need the results from computations that take place in a report to be passed un to a form to put that data in a new table for archive purposes. I know it will require coding, but can anyone help me out with the coding aspect.
Thank you in advanced for your assistance.
martinw

 

[Rich]

I wouldn't recommend it, can't you use a query to return the result?

 

[martinw]

Rich,
I want to keep track of hours spent on a project. When 1.5 hours are reached I need to print a report and pass the information into a table to keep for historical purposes. Then the counter time is reset back to 0 until the next time work is done on the project.
Martinw

 

[Rich]

Then you could use an append and an update query, or eqv sql statements to add the data to the history table and ammend the original, assuming that you'll create separate records in the history table each time the 1.5 hrs is reached.

 

[martinw]

thank you Rich I'll try that

 

[AUR9]

Passing calculated fields to a table

Hi there

Is it possible to output calculated fields on a report in a table.

Say i've a calculated field in report footer which calculates the sum of "total" field in a query which in turn is a calculated field, i know how to output query in a table but please help what can be done in this case, i know its possible but at the moment my brain isnt giving any clue

Any help would definitely be admired