Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

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

Counting

ResolvedVersion 2003

Tue 8 Dec 2009, 16:45 Delegate 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?

Wed 9 Dec 2009, 10:26 Trainer 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 tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Counting

Counting

RE: counting

Access articles

Access tip:

Deleting duplicate records from a table