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

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

Thanks Charity, your name suits you.

Robert

Look at DCount in the Help files

Thanks KevinM


but what about counting strings?

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

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

Is there anything you don't know???

http://www.access-programmers.co.uk/ubb/smile.gif

Thanks

The DCount function will count anything, including string values.