Recent content by shannonphillips

Replacing the " "with [ ] worked Mid(Left([field1],Len[field1])-3),4) many thanks!

pwise option leaves me with 0 phv Access converts to Mid(Left("field1",Len("field1")-3),4) and leave me with blank fields

I have [field1] with a variable length name where I need to remove the fixed proceeding and trailing chars. example ACC1201HOA ACC415HOA ACC1851HOA so end up with just 1201 415 1851 I'm right clicking on the Update to: of my Update query, chosing Build and trying to use some previous RTrim...

I got it, Although the linked tables for the criteria(A&B) where finding the correct records, Table A did not have a primary key define. Table A now has a primary key and the delete query works just fine. Shannon

I don't develope at the SQL level. I have a table(A) with a single stored value in a field, which I link to my master table(B) and the delete query finds the correct citeria, however it will not delete that set of records from a 3rd linked table(C) in another db. Happy Holidays, Shannon

I have 2 copies of my master Table in other DB's, which needs to be updated once a day. The easiet is to delete all and append all, however this is getting to be to large of a task. I have created a table with single field to store a (record_change_date) value in, then tie all 4 of my queries...