COUNTING FIELDS

[JIM1945]

need some help please, I have 5 fields in db 1-message,2-closed,-3-will call back, 4-on property, 5-patched call. I needs to be able to have a count for each field and a total. I use these numbers for billing, after i have printed the monthy report i will need to 0 out the subtotal and the total to 0 to start a new month. thanks

[McCormick]

Try adding some Summary functions that Count those fields. The sumamry field Count.message will be a number that is the number of entries in the message field IN THE CURRENT FOUND SET. So it returns to zero after every time you use it. If you add an auto-enter date field (or perhaps auto-enter just the month), then you can search for that month, and a Count will only count what you find. For some reason (anyone know why?) you can't make a Summary of a Count. But you can make a Calculation field that adds up those Count fields. So create:

Date [auto-enter]

Count.message

Count.closed

etc.

Total [= Count.message + Count.closed+ etc...]