Creating a report based on an update query

[Guest]

I have a database that tracks cost information for our products. Currently, I
have an update query that allows the user to change the price information.
Additionally, I have a macro that emails the results of the query. I would
like to be able to put the results of the update query into a report. I have
created a form that allows the user to select the P.O. number that they would
like to update it's price information (in the query, the criteria is
forms![myform]![PO]). I tried to create a form using the update query as its
control source; however, the update queries that I have in the database are
not listed under the table/query drop down list.

Is it possible to create a report based on an update query? if so,
suggestions on how to start?

Thanks!

 

[strive4peace]

Hi Kate,

an UPDATE query performs an action, it does not show data
.... you need a SELECT query or an SQL statement for your
report to be based on

You might consider this:

add
DateModified, date

to your table. in the code to do the update query and
display the report:
1. set up a variable and record the current date/time
(StartTime)
2. do the update query
3. use the WHERE clause of the OpenReport action to limit
the records to those with DateModified >= StartTime


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*