adding records from one field

[seashton]

I don't know if this is possible or not but I want to add "all the data from a field from all the records prior to the current record" on a single form . Then "the result of this calculation would be used in another calculation on that same current record. How can this be done? Any help or suggestions would be greatly appreciated.

 

[Chris RR]

Don't store the results of a calculation in a field. It's bad database design and will almost always get you into trouble.

The way around this is to create a summary query that contains this info. You can then use this query as the source for reports or forms. The user will never know the difference...