select query

G

Garry

Hi all

When I open a select query, why can't I type in new data ?

Sorry if this sounds daft !

regards
 
G

Garry

Sorry Rick, My select query had the totals button checked. Everything know
fine. Garry
 
O

Ofer

It could be that your update query has more then one table, try and change
the properties of your query.
in the properties change the UniqueRecords Property to true, and try
 
V

Van T. Dinh

Total Queries are not updateable. Hence, you cannot add / edit data in
Total Queries.

If you think about it, a Total Query combine multiple Records into a row in
the Query. If you add / edit data in a row in the Query, how would Access
knows which Record to be updated?

HTH
Van T. Dinh
 
Top