Search results for query: *

ok... basically I am building a query using Access. One of my fields has all the information, but in one full string (like the example I first posted in the topic). I am trying to extract each string piece individually(ie.NAME, ADDRESS, CODE, etc.) so, using the ACCESS Query Design builder...

oh.... nevermind I think I got it... instead of using "="...I use "ADDRESS=" DUH! sorry... thanks guys.

Sorry bout that. I should've mentioned that... Each in its own field. But, when it comes time to trimming the second field (ie. ADDRESS, according to my example), how will an Instr function work...if their are multiples of ";" and "=". won't it just keep outputing the first string inbetween...

Sorry guys...but I am confused. Is the Instr function supposed to work? My problem isn't trimming the first string (ie. NAME=MIKE). My problem is trimming the other strings after the first one... ie. "[ IGOTTOTRIMTHIS ]: NAME=MARK;ADDRESS=777 STREET;CODE=88"

I may have another idea. using a byVal function may work on the field. name:byVal("NAME=",[fieldname]) However, Access recognizes that this is a VB function, and it does not understand. Is there a way to import VB functions to Access?

Ya, unfortunatly they varry in size. I am attempting the Right() and Left(), but for some reason my query is coming out blank. Where could I check for the Right/Left trim tips?

I am in need of help. I need to trim multiple strings from a field in a Access database table. ie. "[ IGOTTOTRIMTHIS ]: NAME=MARK;ADDRESS=777 STREET;CODE=88" How would I just extract "MARK" using the proper SQL statement?

I am in need of help. I need to trim multiple strings from a field in a Access database table. ie. "[ IGOTTOTRIMTHIS ]: NAME=MARK;ADDRESS=777 STREET;CODE=88" How would I just extract "MARK" using the proper SQL statement?