On a report I have customer details including the product they have ordered e.g Growers Choice 2 Min 7 veg £10.00. Is ther a way I can sum all the £ values so I can see what our weekly income will be in total?
On a report I have customer details including the product they have ordered e.g Growers Choice 2 Min 7 veg £10.00. Is ther a way I can sum all the £ values so I can see what our weekly income will be in total?
Well, that's not a good way to store data, but I suppose in the report's source query you can separate out the amount with the Mid() function using InStrRev() to find the position of the last space.
Many thanks for your reply; no my Database is very amateurish but I will try to fathom out how to use your suggestion or maybe a complete rebuild from scratch would be more advantageous
Well, in general you want to store each component separately: product, quantity and price for example. It's a lot easier to join them together to present on a report or whatever than to try to break them apart. There's also normalization, very important:
Fundamentals of Relational Database Design -- r937.com