select query

[Garry]

Hi all

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

Sorry if this sounds daft !

regards

 

[Rick B]

What are you pulling in your query? Is it an updateable query?

 

[Garry]

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

 

[Guest]

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

 

[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