Can I update a table with a query!

[Guest]

I want to update a customers table "print check box yes/no" based off of a
query. I cannot use an update query because this query needs to have an
option to decide at run-time whether to print or not. If I created a form it
would be based off of the same query so that remains the same issue. Hence
the question...Can I update a table with a query? If so how? If not, any
advice on how I can allow the ability to choose certain pages on a report to
print besides the print set up, pages from/to?

Thanks in advance either way,

Ted

 

[John Vinson]

I want to update a customers table "print check box yes/no" based off of a
query. I cannot use an update query because this query needs to have an
option to decide at run-time whether to print or not. If I created a form it
would be based off of the same query so that remains the same issue. Hence
the question...Can I update a table with a query? If so how? If not, any
advice on how I can allow the ability to choose certain pages on a report to
print besides the print set up, pages from/to?

Thanks in advance either way,

Ted

YOu need a yes/no field *IN THE TABLE*, call it PrintMe perhaps.

You'ld base a form on the table (or a sorted query of the table); the
user could check whichever rows they wish to see in the report.

The Report would be based on a query selecting True as the value of
the PrintMe field.

John W. Vinson[MVP]