Counting problem

[puthenveetil]

Hi all,

Can I count the number of records in a table which corresponds to a same fieldname in another table.

thanks in advance


Thanks

 

[WayneRyan]

puthenveetil,

You can try the DCount function:

DCount("[ThatField]", "ThatTable", "ThatField = '" & Me.ThatField & "'")

Wayne

 

[puthenveetil]

puthenveetil,

You can try the DCount function:

DCount("[ThatField]", "ThatTable", "ThatField = '" & Me.ThatField & "'")

Wayne

thanks wayne,

when i tried the function i got #name in the unbound column

can u give me the correct syntax for that:

table1 : Institutions
table2 : Recipients

InstID is a common field in two tables

I want to count Rec_ID from Recipients where InstID is same in both tables.


Thanks are regards

 

[Brianwarnock]

I think the query
SELECT Count(Recipients.Rec_ID) AS CountOfRec_ID
FROM Recipients INNER JOIN Institutions ON Recipients.InstID = Institutions.InstID

should do the trick

Brian