By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,334 Members | 2,746 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,334 IT Pros & Developers. It's quick & easy.

Aggregate Query

P: n/a
Is there a way to create a grouping query and be allowed to edit the
data. I want to create a query that has a grouping and totals but also
allow the user to edit. Can it be done?

May 14 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On 14 May 2007 10:39:13 -0700, John <da********@hotmail.comwrote:

No. All queries with Group By are readonly.

Regular Select queries with perhaps a few DSum columns can still be
editable.

-Tom.

>Is there a way to create a grouping query and be allowed to edit the
data. I want to create a query that has a grouping and totals but also
allow the user to edit. Can it be done?
May 15 '07 #2

P: n/a
How would Access know which records to update?

Now, you could use your query to fill a temp table to be used in a form. You
would need to supply code to update or append records when the temp table is
changed. Realize the temp table is static, any changes to the underlying
tables by other users would NOT be visible to the form.

"John" <da********@hotmail.comwrote in message
news:11**********************@q75g2000hsh.googlegr oups.com...
Is there a way to create a grouping query and be allowed to edit the
data. I want to create a query that has a grouping and totals but also
allow the user to edit. Can it be done?

May 15 '07 #3

P: n/a
John wrote:
Is there a way to create a grouping query and be allowed to edit the
data. I want to create a query that has a grouping and totals but also
allow the user to edit. Can it be done?
You could create a table (MakeTable query). But it wouldn't be dynamic
thus kind of useless.
May 17 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.