Recent content by Kooshster

Ah. I decided just to split up the query into two separate queries, one for each column, and it worked! Thanks very much for all the help with the code.

The example certainly helps process the code, and Access claims that rows are being updated, but for the life of me the fields still aren't updating. Here's my updated code: UPDATE MA2007_10 INNER JOIN [City Municipal Table] ON (MA2007_10.DestCity = [City Municipal Table].DestCity) AND...

I've been tinkering around with the code and came up with this: update [MA2007_10], (select [City Municipal Table].OriginMunicipality, [City Municipal Table].DestMunicipality, from [City Municipal Table]) as [NewCity] set...

This shouldn't be a tough problem, but for some reason I'm stumped. I've got a huge database which has city names in it. The names themselves are outdated and I have to replace the names (e.g. Attleboro Falls is now North Attleboro). There are over 500 names to replace, so I can't do it one by...

Works perfectly! Thanks again.

One more problem: I can't seem to get the other columns to line up one column over - instead of: DunsNumber, Year, Emp, Sales I'm getting: DunsNumber, Year, Emp Sales My code for those lines: SELECT DunsNumber, "1990" as Year, Emp90 AS EMPNEW FROM [Filtered...

It's backwards (91's above 90) but that was easy to fix. Looks like I shouldn't have much trouble expanding the set to the remainder of the data. Thanks so much!!!! :D

I've attached a sample as a .jpg. Here's my new code: SELECT DunsNumber, "Emp90" as Emp, Emp90 AS EMPNEW FROM [Filtered Manufacturing Data] UNION ALL SELECT DunsNumber, "Emp91" as Emp, Emp91 AS EMPNEW FROM [Filtered Manufacturing Data] This seems to be the right track - the Emp columns are...

SELECT DunsNumber, "Emp90_01" as Emp, Emp_01 AS EMPNEW FROM [Filtered Manufacturing Data] UNION ALL SELECT DunsNumber, "Emp91_01" as Emp, Emp_01 AS EMPNEW FROM [Filtered Manufacturing Data] I've just reproduced the first two lines. I've fixed the problem I had earlier - now it's asking for a...

Thanks for the link. I tried the query code and wound up with the following error message: "Duplicate Output Alias EMP" (I'm using EMP as short for Employment).

I'd love to use this code, but I'm not sure where to go in Access to add the code. I know, completely dumb question.

I've got a rather big pickle of a problem that's left me stumped. I have a giant database of some 40,000+ rows, each detailing a company. Columns in this database include employment by year (columned Emp90, Emp91, etc.), as well as sales (Sales90, Sales91, etc.). The data currently looks like...