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.

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...