Hi all,
I haven't used access in a very long time but i need to do this if you can help and i am not sure on the best method or if its possible.
I have the following table:
ID* Name No 1 Jim A1111 2 A1132 3 B3324 4 A1123 5 Harold B1234 6 A4432 7 Jill A1243
I have around 8000 rows of data in a table and I need to just display the Name and 1st A and B that show after the name.....
Jim A1111 B3324
Harold B1234 A4432
Jill A1243
Any ideas on the best solution for this, I have managed to do a query and just display the Name when its <>"" so it shows the first entry but I don't know how to display the next part?
Thanks
Paul