Total in Query

[Guest]

I have a query that represents a schedule for orders my company takes. I had
the query set up so when the order was put "in schedule" to be processed, you
could check a yes/no check box in the query to show this (yes/no field), and
then print it out. However, I had to redo the query, and now am using the
Total option in my query for some calculations. The query now when ran does
not allow me to check and uncheck the yes/no field. I played around and have
come to the conclusion that if you use the Total row, you cannot alter data
in your query, such as the yes/no check option. Am I wrong? If so what can I
do--I need this check option.

 

[John Vinson]

I played around and have
come to the conclusion that if you use the Total row, you cannot alter data
in your query, such as the yes/no check option. Am I wrong?

You are correct. Since each "record" in a Totals query is actually
potentially many records, Access has no reliable way to know which
record you want to update.

If so what can I
do--I need this check option.

Base the Totals query on another query, which itself has the
parameter; or do the totalling in a Form or Report Footer instead of
in the Query.

John W. Vinson[MVP]