problems in showing all data in a report

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

Guest

i have to names in a table that are identical when producing a report i see
all sales grouped to only 1 name please help : )
 
That is what grouping does. If you are grouping by two names and they are
identical then you need another field to group by. Do you have some unique
value associated with the names?

If so, try
Sorting by the names (to give you the order you desire) and then
Grouping by the unique value.

Use the sorting and grouping dialog of the report. (View: Sorting and
Grouping)
 
if this report is a result of a query, try going into the SQL format of the
query and typing "DistinctRow" after the "SELECT" clause in the sentence.
 
You must log in or register to reply here.

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

Similar Threads

Show one report per customer if multiple sales 0
Counting records in group in Details view 4
Grouping and Sorting a Report On Open Event 3
Help Need for Sales Comparison Report 7
Data in a Query not populating in Report 3
Parameter Report with a Chart in the footer 1
Data showing incorrectly in report 9
Bound Chart in Report Issues - Access 2007 4

Back
Top