Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Access Training and help » Counting
Resolved · Medium Priority · Version 2003
Bernard has attended:
Access Intermediate course
in excel i can count charactures in a range like "/" . How I do this on an access table?
Hi Bernard,
Thank you for your question.
There is no CountIf function in Access but you could use the IIF nested within the Count function.
Here is a link to a forum page with some ideas:
http://www.access-programmers.co.uk/forums/showthread.php?t=100040
http://www.techonthenet.com/access/functions/numeric/count.php
I hope this helps.
Regards
Simon
Tue 15 Dec 2009: Automatically marked as resolved.
|
|
Access tip:Space marksIt is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names |
TrustScore
4.9
/ 5
2101 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.33 secs.
