Search results

Thanks Thanks for the responses guys. There are other fields related to the two mentioned above but I'm only interested the part number and quantity fields. Using Alebs suggestion it souldn't be too difficult to get the data I want. I'll give it a go and let you know. Cheers Georg

Thanks Thanks for the responses guys. There are other fields related to the two mentioned above but I'm only interested the part number and quantity fields. Using Alebs suggestion it souldn't be too difficult to get the data I want. I'll give it a go and let you know. Cheers Georg

Thanks for the responses guys. There are other fields related to the two mentioned above but I'm only interested the part number and quantity fields. Using Alebs suggestion it souldn't be too difficult to get the data I want. I'll give it a go and let you know. Cheers Georg

High everyone I've had a look around the FAQ's and other threads but haven't been able to find what I'm looking for. I have a table that contains two fields, one being 'part number' and the other being 'quantity'. Unfortunately there are multiple duplicate 'part numbers'. I am looking at...

Thanks fir the help. I had been putting that statement in the wrong fiel and format. Works a treat. Cheers Georg

I'm currently running a query from several linked tables. One of the columns in a table has data in the following format A11A-11-11. I want to split the data into two new coloumns in the query. The first being A11A and the second being 11-11. How can I do this? Cheers Georg