Count totals from a dropdown

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

Guest

In my form, some of the data has to be selected from a dropdown menu (other
table) On a report, I'm looking to compile them. Ex the table include:
1-Completed 2-Incompleted 3-Pending 4-Refund ... .. ) I want on a report the
total of

Completed: 32
Incomplted: 22
.... and so on.

Thanks
 
Martin said:
In my form, some of the data has to be selected from a dropdown menu (other
table) On a report, I'm looking to compile them. Ex the table include:
1-Completed 2-Incompleted 3-Pending 4-Refund ... .. ) I want on a report the
total of

Completed: 32
Incomplted: 22
... and so on.
Click to expand...


This should be done using a subreport. Create a query base
on the report's record source tabl/query.

SELECT Status, Count(*) As CountOfStatue
FROM table/query
GROUP BY Status

Then create the trivi8al report to display the query's
records and drop it on the main report.
 
Back
Top