View Full Version : Passing Report Data to a Table


martinw
01-06-2004, 11:57 AM
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
01-06-2004, 12:25 PM
I wouldn't recommend it, can't you use a query to return the result?

martinw
01-06-2004, 12:55 PM
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
01-06-2004, 01:15 PM
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
01-07-2004, 12:54 PM
thank you Rich I'll try that

AUR9
04-16-2007, 02:23 AM
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