Parse a filed

[sonny]

I am tring to seperate a field using a query that has data like this:
02 04 08 18 20 25 31 32 35 39 41 45.... (10 sets of numbers)
into there own fields...
I cant seem to find something along those lines!

 

[mhartman]

Hello:
I assume this string of data has spaces between it as shown below. If it does what you want to do is use the "Mid" function to parse your data. Search the Access VBA help. It has good examples. You would use the space character as the delineator.
Regards
Mark