Results 1 to 2 of 2
  1. #1
    Patience is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    May 2010
    Posts
    52

    Count number of identical posts

    Hi guys,

    When a post is shown in a form, I want a dedicated field in the same form to count the number of posts that have a particular field value in common.

    Example:

    Item number: 100
    Name: Cup
    Family: Plastic items

    So now I want a field to count the number of posts that have the same value in the Family field. In this case "Plastic items".

    How can this be done?



    Thank you very much!

  2. #2
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    use DCount

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Automatically delete posts
    By carstenhdk in forum Access
    Replies: 4
    Last Post: 06-09-2010, 02:41 AM
  2. Replies: 3
    Last Post: 12-10-2009, 02:16 PM
  3. Difference between 2 identical tables.
    By leepan2008 in forum Access
    Replies: 1
    Last Post: 09-28-2009, 07:36 PM
  4. Validation on identical text question
    By edrahl in forum Database Design
    Replies: 1
    Last Post: 02-26-2008, 09:38 AM
  5. One table multiple fields identical properties.
    By swampdonkey in forum Queries
    Replies: 2
    Last Post: 09-29-2006, 10:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums