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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top