How do I combine information from multiple rows without getting duplicate values in my report? (1 Viewer)

[Inusah]

I have a table (named: tblSales) with following fields:

SalesAgent
SalesMonth
ProductCategory
SalesAmount

I have information like this:

SalesMonth SalesAgent ProductCategory SalesAmount
Jan A1 W1 5,000
Jun A1 W2 3,500
Oct A2 W1 4,000
Oct A3 W1 2,500
Nov A3 W3 1,500
Dec A1 W1 800
Dec A1 W3 2,000

I want to create an access report that looks like this:
SalesMonth SalesAgent ProductCategory SalesAmount
Jan A1 W1 5,000
Jun A1 W2 3,500
Oct A2 W1 4,000
A3 W1 2,500
Nov A3 W3 1,500
Dec A1 W1 800
W3 2,000

Please assist me urgently.

 

[Gasman]

Look at the Hide Duplicates property of the control

 

[plog]

I would settle for a report that looks like this:

Jan
  A1  W1 5,000
Jun
  A1 W2 3,500
Oct 
  A2 W1 4,000
  A3 W1 2,500
Nov 
  A3 W3 1,500
Dec 
  A1 W1 800
  W3 2,000

That can achieved by adding a SalesMonth Grouping and moving the SalesMonth to it. Then put the rest of the fields in the Detail.

 

[theDBguy]

Hi. Welcome to AWF!

You might need two or three groupings: SalesMonth and SalesAgent (and ProductCategory)