Questions tagged [dcount]
49 questions
0
votes
2 answers
Excel 2010 Count 2 columns when both columns each contain a range of values
I have a large Excel dump from SQL with many columns of data. Two of those columns have different fields with various text values. There are six correct values for the first column and five correct values for the second column. I need to count the…
Craig
- 33
- 2
- 7
0
votes
1 answer
EXCEL - Count participant name (only when all race activities complete)
Thanks for your attention:
I have an ultra-marathon scenario with multiple contestants each competing in multiple events (i.e. swim, cycle, run).
I need a little help on the formula to only count the participants when they have completed all three…
Stuart
- 1
- 3
0
votes
1 answer
How to use DCOUNT on select- sql query while using group by?
How to use DCOUNT on select- sql query while using group by?
I have a problem and first, I want to show part of the real table
Liran Kremer
- 51
- 4
-1
votes
1 answer
Creating a query to count non duplicated patient interactions per day
I am fairly new to Microsoft Access but I recently created a database to better organize our department data. In my database I have a table that our staff can log their interactions with patients. A staff member can have multiple interactions with…
