Counting

The UK's most regular instructor-led training courses.
Training information: access advanced courses · Courses in microsoft access · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Medium Priority · Version 2003

1 post

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

Bernard has attended:
Access Intermediate course

Counting

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

Version	Date	Location	Places available	Book	Next place rate (£)		List price
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice	List price
2010	Thu 16 Sep 2010	Bloomsbury	0	FULL			£299
2007	Wed 29 Sep 2010	Bloomsbury	7		£198	£203	£235
2003	Fri 8 Oct 2010	Bloomsbury	9		£180	£185	£235
2007	Tue 19 Oct 2010	Bloomsbury	10		£171	£175	£235
2007	Tue 9 Nov 2010	Southwark	8		£176	£181	£235
2003	Tue 16 Nov 2010	Southwark	9		£173	£178	£235
Full Schedule: See all 32 Access Intermediate course dates. Bookings currently available until 28th September 2011.

726 posts

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.

· Take an Access Course to Learn About Relational Databases
· Making Figures Talk For Themselves Thanks To Access
· Access And Its Uses On The Web
· Help Business To Go Global With Shared Databases
· Interested In The Golden Rules For Building Access Databases?

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

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms and Conditions

Counting

Counting

RE: counting

Related articles

Access tip:

Hide Access Tables