Editing data in queries

  • Thread starter Thread starter dimpie
  • Start date Start date
D

dimpie

Hi - I have to edit data in a query result. this query has a groupby clause
and lots more, may be that is the reason it is not allowing me to midify the
data.

I have build a form to display all the records of a query result, that i
wnat the user to be able to change??

How can i do this???

I am new to access and any help regarding this appreciated.

Thank You,
 
Queries with Group By are not editable recordsets. The problem is that the
Group By record you see is actually a composite of multiple records.
Therefore, there is not a specific record you can delete.

If you want to delete all records that make up a row in a Group By query,
then you will have to use an SQL Delete query with a WHERE clause that will
include only the related records.
 
A "totals" query (one that involves GROUP BY and/or aggregate functions) is
not updatable, and therefore cannot be used for editing data. This is
because the query has aggregated the data, and it no longer knows the
specific record from which the data came.

You'll need to identify a different query, a "select" query, as the form's
record source query.
 
Back
Top