counting values in a table

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

i need my form to count the values in a table so that when
a certain number is reached it gives a message that table
is full and can no longer accept new record. I can get it
to count only the number of records or only the value 1 i
need it count (sum) the values. The values that are in it
are .5 & 1.


Thanks
 
Okay, I'm confused.

You have a field in a table. The value can be 1/2 or 1,
correct? So, if you had:

Table:
----------
1
1
..5
..5
..5

Would you want: 5 (number of records) or 3.5 (sum of the
values).

If the first, DCOUNT("Field","Table")
If the second, DSUM("Field","Table")



Chris
 
Back
Top