Search results

Hi, I've tried with no luck. I'll keep on trying. Thanks for your comments. Kind Regards

am i missing colons or semi colons?

Hi, Previous script worked a treat. Is it possible to update multiple fields using the same update query I've tried this: UPDATE Table1 INNER JOIN Table2 ON Table1.flda = Table2.flda SET Table1.flda = [table2].[fldb],Table1.fldc = [table2].[fldd] is this possible?

Hi bob, Grateful if you could look up my posting in vba and modules re selective updates. Thanks

Hi Bob, Thanks for your comments. I'll do it your way. Regards

Hi Bob, Thanks again, I think I understand what you mean. Is there some other way of doing this without concatenation, i.e. I would like to copy the contents of the tel Field onto the contents in the Remarks field. Perhaps copying the five characters in the tel field and copying them to...

hi Bob, Thanks again. My remarks field is already in use in several forms. Are you therefore suggesting that I create a third field. Make a table using this third field Then use an update query to update the original table with the concatenated data? Regards

Hi all, is there no way to concatenate without having to create a third field? Grateful if could be done!

Thanks for prompt reply, Should I write this out in the criteria in the design view of the query?

Hi all, Grateful for assistance; I have a table with two fields. Table1 = Tel, Remarks I would like a query which concatenates the data in Tel into the Remarks field, eg. 12345, Happy to be alive the end result in the Remarks field should be: Your old tel 12345: Happy to be alive This...

hi Rabbie, Table 1 = Name, Telephone No ANother, 12345 BNother, 12345 CNother, 23456 Table 2 = Name, Telephone No, New Telephone No In this case I could have three records which look like: ANother, 12345,11111 BNother, 12345,11111 CNother, 23456,22222 I have managed with some previous help...

Hi all, Should i be more specific..

Hi all, Grateful for some assistance or pointers. I have three tables: Table 1 = Master table with a field with old data that requires to be changed Table 2 = table which has the field with the old data and a field with the new data to be swapped. Table 3 = a table similar to table 2 with...

thanks. worked a treat. Just what i needed. no need for lookups! thanks again

Further assistance required?

Hi all, Help needed. I have a table A with a field with names. I have an excel file with old names (similar to table A)with the corresponding new name. I would like to somehow import the excel table into the access database as a table (no problem with that) and then replace the old names in...

Thanks all. Much appreciated.

Hi Mailman, Thanks it worked !!! Thanks again (sometimes it is easier than expected) kind regards

Hi, Done that, but I still get jblogg repeated many times. Perhaps I'm not explaining myself properly. Regards

Hi, Sorry if i've offended anyone for posting the question twice. Anyhow, the answer to your question is not at all. Say for example, the record may hold other data, but I want my query to only display all the payees only once even if they have been paid twice or more. Thanks