Search results

Thanks I'll give that a try

I'm aware its a bad design but am trying to make the best of a bad situation as the database is in use and transferring the data would be very long winded, was looking for a way to get round the flaws. Any ideas on how this could be achieved.

Hello guys New to this forum and new to access (fairly) I'm having to tweak an existing database so am trying to play with what I already have there is a sales table which is set up roughly along th elines of Transaction No., Product 1 Price, Product 1 Type , Product 2 Price, Product 2...