Recent content by DFowler

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