C Cassy01 New member Local time Today, 19:43 Joined Jan 2, 2006 Messages 7 Apr 3, 2006 #1 is it possible to Count If in Access ?? i have two coloums of data and i wish to count 1's form both columns and then 1 from one and 2 from the other and so on. is this possible ?? Many Thanks Benn
is it possible to Count If in Access ?? i have two coloums of data and i wish to count 1's form both columns and then 1 from one and 2 from the other and so on. is this possible ?? Many Thanks Benn
ghudson Registered User. Local time Today, 14:43 Joined Jun 8, 2002 Messages 6,194 Apr 3, 2006 #2 Use the DCount() function with criteria. Search the Access help files for mroe info and examples.