Multiselect listboxs
I am so close but yet soooo far...
I have a form with combo boxes which display the choices from the boxs in a list box.
If you choose from one of the 7 combo boxes it limits the display in the list box, if you choose another combo box, the listbox display is limited...
MichaelRed,
Can you give me more information on how to use the "SPLIT" function in Access 2000?
Maybe that will work for me but I cannot find any "how to's" on this function.
thanks
I need to have access divide it for me.
The database is for someone else, and they cannot split the data themselves.
I need a fomat to parse where it finds a |(pipe).
I am not promting the user for a reply.
I have a field that looks like...
John|A|Doe|30Mar2003|G1
I need to break this down into seperate fields...
i.e.
field one
John A Doe
field two
30Mar2003
field theree
G1
What is the best way to parse this type of data?
Thanks in advance
I am using Access97.
The field in the query looks like...
John|A|Doe|30Mar2003|G1
I need to break this down into seperate fields...
Name Date Dept
John A Doe 30Mar2003 G1
What is the best way to parse this type of data?
Thanks in advance
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.