Countif function in Access

[dougdrex]

I'm using Access 2010 and need to perform the equivalent of Countif in an Access database.

I'm trying to count the number of times an ID appears in one table that match the ID number in a specific record in another table.

For example the ID in Table 1 is 123. That same ID might be in the other table 4 times, or perhaps not at all. I just need to perform a Countif to calculate it in a query.

Any help is greatly appreciated!


Thanks!
Doug

 

[xenou]

A little SQL for this:

select
	t1.id, count(t2.id) as CountOfID
from 
	table1 t1
	left join table2 t2
	on t1.id = t2.id
group by 
	t1.id
order by
        t1.id

 

[dougdrex]

A little SQL for this:

select
    t1.id, count(t2.id) as CountOfID
from 
    table1 t1
    left join table2 t2
    on t1.id = t2.id
group by 
    t1.id
order by t1.id

My query has another couple of fields that are already calculated. Is there a way to incorporate this as part of a query that already exists? Or creating another calculated field?

 

[xenou]

The answer to that depends on the other query you want to incorporate this into - maybe, maybe not.