UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> D Count Multiple Criteria, Access 2010    
 
   
Dale_j1992
post May 19 2020, 10:01 AM
Post#1



Posts: 27
Joined: 24-September 16



Good afternoon All,

This will be an easy one for most people on here.

i am trying to count the number of records in a query in which match 2 criteria, i have tried individually and they work but cant put them together.

=DCount("*","EXCELWIP","[grindingSTATE] = 1")

=DCount("*","EXCELWIP","[model] = 'y'")

how do i combine those to only count the records where the model is Y and the Grinding state is 1.

this is what i tried but it returned a large number i know is incorrect =DCount("*","EXCELWIP","[grindingSTATE] = 1" And "[model] = 'y'")

many thanks
Go to the top of the page
 
theDBguy
post May 19 2020, 10:58 AM
Post#2


UA Moderator
Posts: 78,481
Joined: 19-June 07
From: SunnySandyEggo


Hi Dale. You could try it this way:
CODE
=DCount("*","EXCELWIP","[grindingSTATE] = 1 And [model] = 'y'")

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    11th July 2020 - 06:07 AM