query not updateable? 1

[simon551]

Hi, I can't figure out why this isn't an updateable query (access 2007)

SELECT [_vendorJoin].joinId, [_vendorJoin].vendor_et, [_vendorJoin].vendor_or_othername_qb, [_vendorJoin].qb_type, [_vendorJoin].[qb_othername-overwrite]
FROM _vendorJoin INNER JOIN [_temp_ettrans-received_cc_vendors] ON [_vendorJoin].vendor_et = [_temp_ettrans-received_cc_vendors].vendor;

It's just 2 tables with a text field join. Seems straight forward enough but maybe I'm rusty...

 

[simon551]

Strike that last sentence. It's actually one table I'm trying to update with a filter based on the join field and second table. The query is returning 25 unique records.

 

[SkipVought]

...because it's only a SELECT query?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

Sorry, is the query depending on some aggregation in the other table?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[simon551]

nope

 

[SkipVought]

So will the real SQL please stand up.

Your latest and greatest, please.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[simon551]

That is the full SQL. The first table has roughly 500 records and I just want to go through the records that I need right now which are the ones that match to the second table (the temp table)which is why I create a join. I use the second query to filter the records and then I want to be able to manually update fields in the first table.

 

[SkipVought]

No Database Functions being used for field data in either table?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[dhookom]

Are the tables joined on primary and foreign keys? They should be if you want the results to be editable.

Duane
Hook'D on Access
MS Access MVP

 

[simon551]

got it! thanks! I new I was rusty!