Recreating an Excel Query in Access (1 Viewer)

helen48

New member
Local time
Today, 22:56
Joined
Sep 21, 2015
Messages
1
Hi
I am new to the forum so you will have to bear with me ...
I have a table in access with I use Count if formulas in and I was wondering if I could replicate it in access ( I now have to much data for excel to handle)


the formula I currently use in excel is
=COUNTIFS(Sheet1!N:N,'Sheet3'!E4,Sheet1!O:O,Sheet1!$O$7,Sheet1!L:L,Sheet1!$L$2)


is there any way of replicating this in access in either a query, crosstab query, or report ?


Kind Regards


Helen
 

namliam

The Mailman - AWF VIP
Local time
Today, 23:56
Joined
Aug 11, 2003
Messages
11,696
Looks like a simple group by / count query ... assuming you have sheets 1 and 3 as tables...

Though it - to me - doesnt make much sence to count O7 in the column O

you will have to bear with me
If I only had a nickle for every time :) welcome to the forum
 

Brianwarnock

Retired
Local time
Today, 22:56
Joined
Jun 2, 2003
Messages
12,701
I would tackle this using the Sum(Iif(. Approach.
Your query would have three cols of the form

Count1: Sum(IIf(field1="A",1,0))

Brian
 

Users who are viewing this thread

Top Bottom