Grouping Data

[BecksWatkinson]

I have a subform that shows a usual set of data such as:

Name1 Product1
Name1 Product2
Name1 Product3
Name2 Product4

The client wants me to be able to do the following:

Name1 Product1
Product2
Product3
Name2 Product4

I.e. merging data cells where they are the same value

Preferably with Name1 being centered across the products. Within a
straight access form I would use a group via crosstab however this is
an access adp on SQL Server.

Can anyone help?

 

[Guest]

Sorry, Access is not a spreadsheet, it is a relational database application
builder. You can't do that.

 

[Guest]

In a report you can hide duplicates.

 

[BecksWatkinson]

Ahh but actually you can .......didn't realise you could use a
crosstab grouping form on an adp same as you would on an mdb.