[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

How do I count criteria from a dropdown list on a form in a Microsoft Access report?

Posted on 2014-02-12
3
Medium Priority
?
483 Views
Last Modified: 2014-02-13
I have a combo box linked to field "Case Contact Method" with "Face-to-Face", "Phone", and "Other" as the drop down list criteria. The user will click a button which will prompt for start and end date then run a report (based on a query) pulling first name, last name, and Case Contact Method. This list is populated. I have a total count for all contacts but would like a broken down count for each at the bottom of the report based on the dates provided in the date range prompt mentioned.

I believe this would require a DCount function but I cannot get the syntax right.
0
Comment
Question by:OneByte
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 39

Accepted Solution

by:
PatHartman earned 1500 total points
ID: 39854261
You could use DCount() but then you'd need to know what all the values are and modify the report if they changed.  I would create a totals query and add a subreport to the report footer to display it.  It will be sort of a recap.

Select ContactMethod, Count(*) AS RecCount
From YourTable
Group By ContactMethod
0
 

Author Comment

by:OneByte
ID: 39854425
Works out fine with the query as a sub report. Thanks. It's not that big of a deal but is there a way I can have the others listed and displaying zero if there are none within the dates set?
0
 
LVL 39

Expert Comment

by:PatHartman
ID: 39857425
If you have a table that has a complete list, add that to a query and use a left join that says select all rows from the list table and matching rows from the table with the data.
0

Featured Post

What’s Wrong with Your Cloud Strategy ?

Even as many CIOs are embracing a cloud-first strategy, the reality is that moving to the cloud is a lengthy process and the end-state is likely to be a blend of multiple clouds—public and private. Learn why multicloud solutions matter in this webinar by Nimble Storage.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question