Unable to enter data onto a query or form

[Guest]

I am trying to add a field to a query from a table. There are approx 63
fields. When I try to enter the new field, I am then unable to enter
information to the query or the form. The "Totals" field in the query all
turn to "Expression" from "Group By". I have rebuilt the query, but the same
thing happened. I am still able to enter the information to the Table--just
not the query or the form. What could be causing this? I have copied the
SQL view from a database backup to get the query to work again, but as soon
as I try to enter another field, I am unable to enter any new data.

 

[Douglas J. Steele]

You shouldn't be using a Totals query if you want the query to be updatable.

 

[Rick Brandt]

I am trying to add a field to a query from a table. There are approx
63 fields. When I try to enter the new field, I am then unable to
enter information to the query or the form. The "Totals" field in
the query all turn to "Expression" from "Group By". I have rebuilt
the query, but the same thing happened. I am still able to enter the
information to the Table--just not the query or the form. What could
be causing this? I have copied the SQL view from a database backup
to get the query to work again, but as soon as I try to enter another
field, I am unable to enter any new data.

NO query with View - Totals enabled will ever allow updates to its
datasheet.

Read the help file topic "When can I update data in a query?" There are
numerous situations where you cannot.

 

[Guest]

Thanks!!!
--
Ronnie

NO query with View - Totals enabled will ever allow updates to its
datasheet.

Read the help file topic "When can I update data in a query?" There are
numerous situations where you cannot.

 

[Guest]

Thanks!!!
--
Ronnie

You shouldn't be using a Totals query if you want the query to be updatable.