RE: Count Fields on a Form or SubForm

Sorry, follow up....

Ok, so I made the new table as suggested, with just the ID Number, an auto
ID, CType, CDate, and CTime.... So if I leave the record selector on the
subform, the person can scroll and add multiple contacts, and it associates
it with the ID Number (I had to use the ID Number, since the auto ID can only
have 1 association)...

If that tracks the contacts on the form, how would I create a Query to count
the different types of contact Types for a specific ID.... in other words, I
want that sum (total number of Family contacts, total number of Individual
contacts, etc), put on the form, so although you can't see all the contacts
spread out, it'll give you a running total.... in addition, I want to count
the sum of the time entered... but I would assume the process would be the
same, if I can figure out the contact types....

I can see in the Table, when I enter 3 contacts for ID 6534, that it simply
enters those in the table... but how would I make it count contact types for
specific IDs on a form?

Thanks...
.

Relevant Pages

  • Re: work only with value without updating
    ... you could easily create a one variable data table ... *It can any empty cell outside of the range C2:D11 ... and must do it in many time, in other world i need sum of many random ... but this have 3 realy big problem and that is you must use auto fill step by ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Fortran vs. C++ : Which is best to choose now i
    ... > and calculate the average and standard deviation for both times. ... auto = 7.039 ... alloc = 7.404 ... * time calc'ing sum ...
    (comp.lang.fortran)
  • work only with value without updating
    ... and must do it in many time, in other world i need sum of many random ... number in many time and each time must give a seperate number of sum. ... but this have 3 realy big problem and that is you must use auto fill step by ... cell to have sum of past value that maked with random function, ...
    (microsoft.public.excel.worksheet.functions)
  • If Function Treating Answer as a Text Box and Not a Numeric Box
    ... I'm creating a scoring matrix which auto assigns values based on another ... i would like to sum all the values. ... would I change the following to get it to kick out values as text? ...
    (microsoft.public.excel.misc)
Quantcast