Search results

Try this Make sure in your query, the value comes from the table where the text is and not the table holding the numeric value for the lookup.

Thanks Neil, That's not such a bad solution. I'll play around with that idea. I was originally from Hartlepool, not too far from Newcastle, so I appreciate your Andy Capp logo. Cheers

Hello there, I have a query that calculates price x quantity. That bit is easy. However from time to time my suppliers will issue a detailed quotation (ie lots of items, lots of prices and lots of quantities), then one week later issues the exact same quotation but with price changes and/or...