Prev: Eliminate 0 value in crosstab
Next: SQL of above
From: ken957 on 27 Jun 2008 15:55
I have a very long table using a limited number of company names, I have
another long table with many of the same or similar company names. I wanted
to make a table without duplicates of the the company names used in the first
table, then work on establishing relationships with the names from the second
table.

I made a table with only three fields, autonumber, CompanyNameListA,
CompanyNameListB. I pasted all 20,000 plus companynames from listA, made a
totals query grouping on company name and using MinOf the autonumber field.

My delete query correctly displays the records I want to delete but only
gives the "cannot delete from specified tables" error

The only relationship between any tables/querys is between company names
from ListA and the Totals Query


--
ken
From: Duane Hookom on 27 Jun 2008 16:06
Any query that contains GROUP BY in it or one of its sources is not
updateable. I generally create a table based on the GROUP BY query and then
define its primary key. Use this new query in place of your totals query.

--
Duane Hookom
Microsoft Access MVP


"ken957" wrote:

> I have a very long table using a limited number of company names, I have
> another long table with many of the same or similar company names. I wanted
> to make a table without duplicates of the the company names used in the first
> table, then work on establishing relationships with the names from the second
> table.
>
> I made a table with only three fields, autonumber, CompanyNameListA,
> CompanyNameListB. I pasted all 20,000 plus companynames from listA, made a
> totals query grouping on company name and using MinOf the autonumber field.
>
> My delete query correctly displays the records I want to delete but only
> gives the "cannot delete from specified tables" error
>
> The only relationship between any tables/querys is between company names
> from ListA and the Totals Query
>
>
> --
> ken
 | 
Pages: 1
Prev: Eliminate 0 value in crosstab
Next: SQL of above