Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Permanent Total Field
- Thread starter Ilene
- Start date
In limited circumstances, yes. If the summary calc will evaluate on a form in browse mode, its value can be stored in a database field by the macro Set command.
This type of summary only works on a form based on a parent tabel and when it summarises records in a detail table. The summary option must be set to "All records in xxx" where xxx is the name of the detail table.
Summary calcs with option "Summaries where placed" won't evaluate in browse and therefore aren't available to the Set command which only works in browse. They only evaluate in print preview in the context of the panel in which they're placed. However you can use Edit - Copy View and paste a report as raw data into a 1-2-3 spreadsheet. You can delete what you don't want and save the remainder as a dbf which can be imported by Approach.
Paul Bent
Northwind IT Systems
This type of summary only works on a form based on a parent tabel and when it summarises records in a detail table. The summary option must be set to "All records in xxx" where xxx is the name of the detail table.
Summary calcs with option "Summaries where placed" won't evaluate in browse and therefore aren't available to the Set command which only works in browse. They only evaluate in print preview in the context of the panel in which they're placed. However you can use Edit - Copy View and paste a report as raw data into a 1-2-3 spreadsheet. You can delete what you don't want and save the remainder as a dbf which can be imported by Approach.
Paul Bent
Northwind IT Systems
- Status
Similar threads
