Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: shannonphillips
- Content: Threads
- Order by date
-
variable length trim of unwanted chars
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...- shannonphillips
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
-
External Parameter Delete Query
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...- shannonphillips
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
