Passing Report Data to a Table

martinw

Registered User.
Local time
Today, 22:41
Joined
Oct 31, 2001
Messages
11
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
 
I wouldn't recommend it, can't you use a query to return the result?
 
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
 
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.
 
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
 

Users who are viewing this thread

Back
Top Bottom