Search results

Of course I have done a compact and repair. It is so large because it is 3 years worth of data and I have used a union query. The data I have I need thus the reason why it is there. The invoice date has changed due to split shipments. We are invoiced for stock received. The problem is when...

I know the size by looking at the size of the database really. As mentioned in my first post I have order numbers that repeat the reason for this is because the invoice number is different. I want to combine them so the order numbers only appear once

Yes unfortunately I need to keep the invoice dates

Hi All, I have 2 gig of order data which has duplicates due to different invoice dates. How can I combine the dates into one cell so I only had one row of Order data. i.e. order number, price, order date, invoice date same order number, same price, same order date, different invoice date...