Counter

  • Thread starter Thread starter Harvard
  • Start date Start date
H

Harvard

I'm trying to figure out if there is a way for access to
display how many of a particular record i have. for
instance, i created 2 forms. one with last name, first
name and personalID (#). the second form has semester,
personalID, rank, type, and nature. so, i was wondering
if there is a way for access to automatically generate how
many records i have for a particular term? For instance,
how many contacts I have for a certain person under a
particular semester?
 
You can do this with a calculated query. Click the summation symbol on the
query grid.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...
 
This is easier to demonstrate than describe, but let's see how we go....

Open the query, and click the summation symbol on the toolbar. (That's the
funny sort of S.) That will add a "Total" row to the grid on the bottom.

Select Group By for Student, and Count for your contact field.

If that doesn't work, tell me how your tables are set up and I'll try to be
a bit more specific.

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

Harvard said:
I don't know where to start. I made the query, but i don't know how
Click to expand...
to set up the calculation part. I want it so that access automatically
counts how many contacts for each student on a given semester. I just can't
figure out how to set it up. Any advice would be greatly appreciated
 
Back
Top