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?
Novice
Windows 7 64bit 
Access 2003
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?
Who is John Galt?
Windows XP Access 2007
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.
Novice
Windows 7 64bit Access 2003
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
Who is John Galt?
Windows XP Access 2007
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
Part of field matches part of another field
Posting Permissions
Reply With Quote