Coulkd any one explain this query to me especiall the Where clause where we use forms what does that mean and any examples you have please let me know.
thanks
srinivas somanchi

SELECT COUNT(*)
FROM tblintstudents
WHERE (tblintstudents.Citizen IN
              (SELECT DISTINCT tblRegions.CountriesInRegion
               FROM tblRegions
               WHERE (tblRegions.GlobalRegion = [Forms]![frmRegGlobal]![txtGlobalReg] )
              )
);

Hi,



1-It counts all records from table tblinstudent then
2-Selects distinct citizen records that are in table tblregions
and only
3-Records that match in table tblRegions, GlobalRegion using records that is the form frmregglobal txtglobalreg textbox.

To clarify jemacc's post,
basically, it counts the number of students that come from a particular region

I am a loud man with a very large hat. This means I am in charge

 

returns a set of values that the query uses as criteria by using the In() clause. For instance:

In(1,2,3,4,5,7,8,9)

would return any values from one to 9 not including 6.





Sal