1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

counting records in access

Discussion in 'Business Applications' started by mcookaz, Oct 28, 2004.

Thread Status:
Not open for further replies.
  1. mcookaz

    mcookaz Thread Starter

    Joined:
    Jun 6, 2002
    Messages:
    160
    i have an access file that has two tables. one table lists all the foremen and the other has the inspections. i want to print a report that shows how many inspections each foreman has. some foremen will not have any inspections. the two tables are linked together already.
     
  2. Agoo

    Agoo

    Joined:
    Oct 27, 2004
    Messages:
    12
    If the inspection table has the field references the foreman, then use the following select statement.
    select foreman,count(foreman) from inspection table group by foreman
    Regards/Agoo
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - counting records access
  1. sia123
    Replies:
    5
    Views:
    423
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/289946

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice