The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Counting

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Counting

Resolved · Medium Priority · Version 2003

ReplyTue 8 Dec 2009, 16:45Delegate Bernard said...

Counting

in excel i can count charactures in a range like "/" . How I do this on an access table?

For upcoming training course dates see: Pricing & availability

ReplyWed 9 Dec 2009, 10:26Trainer Simon said...

RE: counting

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 articles

· Get To Know The 3 As: Access Accuracy Achievement
· Discover Decisive Details In Your Data, With Access 2010
· How to Find a Third-Party Venue for Microsoft Access Training
· Record, Find And View Data Easily Thanks To Microsoft Access
· Access VBA Handling Errors and Debugging Code

Please browse our web site to find out more about
access advanced courses and other Microsoft training courses.

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown

View all Access hints and tips

How can one create index/match formula in VBA?

» Forum post: Index formula

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions