Recent content by djmousie

Getting the error "Operation must be an updatable query"...

Hmm, gets caught up (highlights) the last "AS" int he statement and stating SYNTAX error in update statement.

Any help on the SQL by any chance? Im better at the GUI JET SQL...if what you say above should work then results should be... MAKE TABLE QUERY RESULTS Auto # Account # Qty Table 2 Qty 1 123 25 50 2 123 25 <NULL>

There is no current primary key then. I was helped on thread701-1391321, however, I had thought there was an effective dated field (and there wasn't) and I need to somehow have the same effect with the below code, but removing any mention of effecting dating and just update based maybe on...

The primary key is Account #, it does not matter which row it updates.

Any thoughts?

I was helped in another thread in relation to this problem, but ive tweaked my needs and now im not sure how to resolve... I currently have two tables. The MASTER TABLE has a list of accounts and quantities. The SECOND table has additional quantities that need to be merged in by account #...

Actually one more, thing. What if i removed the dating piece all together and I only wanted QTY2 to appear next to one of the similar account #'s, like below... MAKE TABLE QUERY RESULTS Account # Qty Table 2 Qty 123 25 50 123 25 <NULL>

Yes, that works perfectly, thanks a ton!

That sort of worked,not sure if it's me that did it wrong, but its summing Qty2 twice, so in the example above, Qty is coming back as 100 not 50.

I currently have two tables. The MASTER TABLE has a list of accounts and quantities ordered by effective date. The SECOND table has additional quantities that need to be merged in by account #, however,the quantities need to be merged on where the earliest dated account row is. For example...

I'll give that a try. Thanks

3 - Or possibly only update so many records at a time so it doesnt run out of memory?

I have an access table that is over 2 million records. I can't chage the data type on one of my fields because i am getting an error message stating that there isnt enough space or memory... 1 - Is there a work around? 2 - If not, can an update query be written so that I can update the data...

that would be much appreciated! Thanks