Can access count??? (1 Viewer)

[robertbrockie]

I have a database that inputs the countries that international students are from. I was wondering if I can create a report that counts those countries, and will update when a new student is added.

Thanks for your time,

Robert Brockie

 

[charityg]

I'll send you the query that will accomplish this.

 

[robertbrockie]

Thanks Charity, your name suits you.

Robert

 

[KevinM]

Look at DCount in the Help files

 

[robertbrockie]

Thanks KevinM


but what about counting strings?

[This message has been edited by robertbrockie (edited 05-04-2001).]

 

[charityg]

Create a new report and use the sql statement I emailed you as the datasource.

 

[robertbrockie]

Is there anything you don't know???

Thanks

 

[KevinM]

The DCount function will count anything, including string values.