Joining table with query based on itself.

[Moss100]

Hello, I am hoping to have a query based on a table which I can use in other queries. The query would contain a number of calculation fields (such as concatenated names etc) . I am hoping that this will make development and future maintenance easier.

So….

I have a table tbl_Clients

I have a query based on this called [mqry_Tbl_Clients]

This query contains all the fields from tbl_Cleints and additionally some calculated fields to concatenate names etc.

I would like to be able to create a further query:

This would use ALL fields from tbl_Clients and just the concatenated fields from [mqry_Tbl_Clients]

When I create the new query, it automatically joins the two ID fields correctly, but then the resulting recordset is not updateable.

Is there another approach or solution to this?

Thank you Mark

 

[dhookom]

Share your SQL views of your queries as well as identify the primary key field(s).

Duane
Hook'D on Access
MS Access MVP