Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old August 1st, 2006, 02:50 PM
Registered User
Join Date: Aug 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Viewing Multiple Related Records

Hi All Please help me,

I have two more problems.

I have a tabular form, with the fields are:

Employers, Test, Employer_Building, Employer_Site

Rod Junit 1 a
Pradeep WinRunner 2 b
Reddy Junit 1 b
Vincent Junit 8 c
George WinRunner 4 a
Kate Junit 1 a
Chris WinRunner 1 a

when I want to search records. ie.

   I want to find how many Employers testing the Junit.
   and like wise other tests.
   I want that if 5 employers are doing Junit that should show up 5 records in the Tabular form
   If its 20 should show 20 in tabular form.
   Any idea...please

Any input will be greatly helpful..please....
  #2 (permalink)  
Old August 1st, 2006, 11:07 PM
Authorized User
Join Date: Apr 2006
Location: , , .
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts

create a seperate query that groups and counts the number of tests by type.

Then create a query that uses that query along with the table and add an additional field that includes the count.

Similar Threads
Thread Thread Starter Forum Replies Last Post
displaying multiple non related tables in gridv shoakat ASP.NET 2.0 Basics 7 September 11th, 2007 04:21 PM
Selecting one of possibly many related records rodmcleay SQL Server 2000 2 March 24th, 2007 12:49 AM
Create Related Records twsinc VB How-To 2 October 31st, 2006 06:51 PM
insert related records Haroldd Classic ASP Professional 2 April 15th, 2004 02:10 PM
viewing records sinner Classic ASP Databases 2 March 20th, 2004 06:08 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.