Summarising by 1st 3 Characters

  • Thread starter Thread starter sue
  • Start date Start date
S

sue

I have a query that lists lines of sales - they have a
product code against them of W/W or W/W JL or W/W FW or
F/V or F/V JL or F/V. I need to create a summary,
totalling lines using the first 3 characters of the
product code. i.e all the W/W and all the F/V

Any help greatfully received!

Sue
 
Back
Top