The Count Function not working properly.

[Lamont1701]

I am using the “count function” on an MS Access 2003 Form field. The count function seems to be working fine except it is not placing the result into the table field.

Does anybody know what I am doing wrong?

Can someone show me the proper format for using the count function used on a form field, where the result is to be placed in a table field?

Please Help!!!



Seti UNIVERSE
http://www.setiuniverse.com/
All of the SETI (The SEARCH for EXTRA--TERRESTRIAL INTELLIGENCE) disciplines in one place.
(Radio, Optical, Microwave, and Amateur SETI)
Stop by Seti UNIVERSE and find out, what you didn't know about SETI.

 

[Pat Hartman]

Calculated values shouldn't be stored. The Count() function as well as other aggregate functions only makes sense when used on a subform or in a report.