Search results

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...

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