pls........ help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi every One,
I have data like
PCode SellAmount
D101 45
D102 30
B201 15
C501 25
B202 15
The code beign with letter(D=drink, B=Biscuit,C=cigarate etc.)
I want to make a report like
Sum of Drink 75
Sum of Biscuit 60
Sum of Cigarate 25

Pls help me to do this.
Thx & Regards,
Nad
 
You can/should create a table like:
tblCodes
===============
Code CodeTitle
D Drink
B Biscuit
C Cigarate
....

Add this table to your report's record source and create a column with the
expression:

CalcCode: Left(PCode, 1)

Then set the criteria under this column to
Code:
 
Back
Top