Join queries now not updateable. Need HELP

  • Thread starter Thread starter Cynthia
  • Start date Start date
C

Cynthia

I have 2 queries that are updateable until I join them.

My first query is of a table that has a float field (lets call it SDL) that
is not unique. In this query I am doing a select where one field is like
"R*" to try and get rid of the duplicate SDL's.

My second query I have a table with the SDL field as the primary key. There
are fewer SDL numbers in my table than are in my first query.

I am joining both queries where the SDL fields are equal. Both queries are
updateable until I join them together.

below are the 2 queries:
1st qry
SELECT DISTINCT Components.ComponentIndex, CommonData.ReportedLineNo,
Components.solodatalink
FROM Components INNER JOIN CommonData ON Components.CommonDataLink =
CommonData.CommonDataLink
WHERE (((Components.ComponentIndex) Like "r*"));

2nd qry
SELECT InstIndex.SDL, InstIndex.LoopNo
FROM InstIndex INNER JOIN [Copy Of InstIndexqry] ON InstIndex.SDL = [Copy Of
InstIndexqry].solodatalink;
 
Sorry, but your first query is NOT updatable. A DISTINCT query cannot be
used to edit/update data because it's a summary (grouped) set of your data.

And if you join an updatable query (your second query) to a nonupdatable
query, the result ALWAYS will be a nonupatable query.
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/
 
Thank you I am so sorry I thought I had taken the distinct out
--
Cynthia


Ken Snell (MVP) said:
Sorry, but your first query is NOT updatable. A DISTINCT query cannot be
used to edit/update data because it's a summary (grouped) set of your data.

And if you join an updatable query (your second query) to a nonupdatable
query, the result ALWAYS will be a nonupatable query.
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


Cynthia said:
I have 2 queries that are updateable until I join them.

My first query is of a table that has a float field (lets call it SDL)
that
is not unique. In this query I am doing a select where one field is like
"R*" to try and get rid of the duplicate SDL's.

My second query I have a table with the SDL field as the primary key.
There
are fewer SDL numbers in my table than are in my first query.

I am joining both queries where the SDL fields are equal. Both queries are
updateable until I join them together.

below are the 2 queries:
1st qry
SELECT DISTINCT Components.ComponentIndex, CommonData.ReportedLineNo,
Components.solodatalink
FROM Components INNER JOIN CommonData ON Components.CommonDataLink =
CommonData.CommonDataLink
WHERE (((Components.ComponentIndex) Like "r*"));

2nd qry
SELECT InstIndex.SDL, InstIndex.LoopNo
FROM InstIndex INNER JOIN [Copy Of InstIndexqry] ON InstIndex.SDL = [Copy
Of
InstIndexqry].solodatalink;
Click to expand...
Click to expand...
 
Back
Top