Search results

I want to store the max value of the history table as this is what the customer sees. in essence this isn't a wholly access based question as it is mainly trying to find the sql coding required to update from history Max to other table

I am currently trying to update a table with the Max values from the below query. select debtepisodes.accounts1,deepisodenum,Max(dehepisodenum) from debtepisodes,debtepisodeshistory where debtepisodes.accounts1 = debtepisodeshistory.accounts1 group by debtepisodes.accounts1,deepisodenum...

Ok now to the answer, The query should just be returning one field based on certain criteria from a combo box on the form, so for instance if the user selects Plant type the query returns a letter which correlates to something else further on in the process, Strangly this aspect works its just...

Hopefully this is something quick and easy i currently have a form which is using a particular query to populate the fields etc. I have one field that i need to be based on a seperate query altogether, i have tried almagamating the queries but this does not work, Is there some code that will...

Hmm how strange the error is attached (hopefully)

Next installment in the never-ending query i am using the below code :- UPDATE Addressdata SET TAddressdate.AddressSearch2 = (Mid(Addressdate.AddressSearch, 1, Instr( 1,Addressdate.AddressSearch, ",,", 1))+2 (Mid(Addressdate.AddressSearch, Instr( 1,Addressdate.AddressSearch, ",,", 1)+2...

Ok will give that a go as u responded to my question before i posted it which i gotta admit is quite a talent

So in essence if i understand what your saying, I should be using UPDATE Table SET Table.FieldNew = (Mid(Table.Field, 1, Instr( ,Table.Field, ",,", 1)+2 (Mid(Table.Field, Instr( ,Table.Field, ",,", 1)+2, Len(Table.Field)) and if that fails i should be using UPDATE Table SET Table.FieldNew...

thankyou you for your pleasant response but I directly copied your fix that u suggested but this caused other errors which were only fixed via the removal of the first comma in front of the table name and the addition of the second bracket after the 2

Right have tried all the above and the attached is the error that is now being received

Prob a real simple answer to this issue that my colleague is having, Is there a way within an updat query that ",," can be replaced with "," we have tried placing these into an update query but it doesn't seem to pick up the ",," as they are mid string on the table.

Re: The Microsoft Jet database engine cannot find a record in the table <name> with k Lol yeah did that, reset them up and woooo got a new error message this time, Seriously thinking i might just go kill myself shortly lol, new error message is as attached

Re: The Microsoft Jet database engine cannot find a record in the table <name> with k I have attached the relationship

Re: The Microsoft Jet database engine cannot find a record in the table <name> with k I changed the 0 and still same error as attached

Re: The Microsoft Jet database engine cannot find a record in the table <name> with k Right have attached a screenshot of both tables and of the form in question i know its gonna turn out to be something really simple, but brain is beginning to implode now lol

Re: The Microsoft Jet database engine cannot find a record in the table <name> with k Right yeah, my bad shoulda explained myself better, The one table is updated on the same form so is always populated first with the autonumber and other details the Many table is then updated via a subform...

The Microsoft Jet database engine cannot find a record in the table <name> with key m Right then people this is probably something mega easy but i am having a mare with it at current as no matter what i try i get the above error, I have a parent child relationship based on a Primary key...

I have now passed on this as i needed to have it done before 2 so have gone to the mailmerge tactic i will undoubtedly try and use this code in the future, Thanks for all your assistance tho, (I was a Mr last time i checked)

It is just literally the 8 address fields that require the change i know its a simple task to do on a mail merge but i was trying to avoid moving data in and out of the database, I am guessing that is going to be my only option if i want ease

I thought about that as an idea but would that not then cancel out the way it looks ie. it would no longer be in a list format? If this is not the case can you nudge my brain in the right direction with a more detailed explanation?