Search results for query: *

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

Well the problem with using a Macro with a master sheet is, that I have about 60 seperate workbooks that spit out once the query is finished. I'd have to open up each sheet individually to reformat, that is what I am trying to avoid. Thanks again with the follow up and come home safe.

Yah I was able to get that to work, it's properly formatting the excel sheet (custum headers) and column widths and what not that I was also trying to add to the code. Since I have about 60 spreadsheets of data that exports, they all export unformatted. See what IM saying?

Unfortunetly, I gave up on the project a while back due to other priorities. Like I said, the original code will spit items into excel from access, but WITHOUT the proper formatting. I've been to many other forums to get other opinions. Some have tried to help, but nothing quite worked the...

Skip, I am trying to avoid having to select each vendor since there are so many, I understand what your saying above, u would choose a vendor from the combo box and click on a command button, but I need something that will choose all vendors and create a spreadsheet for each vendor...I'm sorry...

Skip, What are your thoughts on the following code...I understand what you are trying to have me do above, it's sort-of what Id like to do, but I've gotten some feedback, and the below code is close, but I am still getting a run time error 3001 "Arugments are of the wrong type, are out of...