My first post :)
I have a small problem I have an Access Database with several tables. One of these tables is a list of sites in one column and in each sites row is list of infomation stored in one cell but in delimited format. how do i get VB to search for a pericular site then pull all the delimted information in that row into my application (dataset or other) so i can display it in a data grid or preform a SQL search on it.
sorry not very clear hope this helps a little comma being the delimiter
table is called sites
---------------------------------------------------------------------------------
0 | 1 | 2 | 3 |
---------------------------------------------------------------------------------
London | 1,2,3,4, | mon,tues,wed,thur | 320,400,300,200 |
---------------------------------------------------------------------------------
Exeter | 1,2,3,4 | mon,tues,wed,thur | 450,500,630,230 |
---------------------------------------------------------------------------------
Hull | 1,2,3,4 | mon,tues,wed,thur | 340,450,500,300 |
---------------------------------------------------------------------------------
what i want is to be able to select either london,exeter,hull from a dropbox and then it builds a dataset/recordset for example
called london that looks like this
-------------------------------------
0 | 1 | 2 |
-------------------------------------
1 | mon | 320 |
--------------------------------------
2 | tues | 400 |
--------------------------------------
3 | wed | 300 |
--------------------------------------
4 | thur | 200 |
--------------------------------------
does that make sence sorry for not being clearer
thanks in advance you'll be saving my bacon :)