[COMBINE SEVERAL TYPES of QUERIES] EDIT AND ANALYZING QUERIES TOGETHER

[anne_l]

Hi,
I would like to create a query combining several tables that are related by primary and foreign keys of course.
I would like to make this query editable.
I saw this is possible when you use the "update" button.
The problem i have is part of my query use "anaysis" (putting fields'values as columns) and it seems not possible to edit a analysis query.
I never coded in my life and just start with access.


I would like to know if this is possible or not

Thanks a lot for your help!


Anne

[Micron]

There are many reasons why a query may not be editable.
It sounds like you're saying this is a cross tab query and if that is the case, the article says it's not possible.

[anne_l]

Thanks, i saw it was not designed to make it possible already, but i wondered if there was an alternative way to do it.
Btw they dont' explain why, they just say it's not possible if you use some operators, but if you have a unique value in your cell, that would have been great to let it editable.

[Minty]

If it is a cross tab, the only way to allow you to update it would be to dump the query results into a temporary table.

You then have the entertainment of "unpivoting" the temp table data back into your original data tables after updating it, not a trivial task unfortunately.

[Gicu]

Usually you don't allow users to work directly with tables and\or queries, so instead of editing directly in the query you should look into using a form bound to that query. Now in a form, using VBA, pretty much everything is possible... And the form can be a datasheet that would look similar to the original query.
I suggest you prepare a small db sample with just the objects involved and no private\sensitive info and post it here so we can have a look.

Cheers,