Many years ago I created a database to generate end of month reports in Access 97. 7 separate queries filtered the information from 2 large tables and placed it into 7 separate forms. Each form then had totals calculated on it within the forms code:
e.g.
Table Field: "Gross income"
Client1: 20
Client2: 30
Client3: 10
Table Field: "Commission"
Client1: 2
Client2: 4
Client3: 3
Calculated Form field: "net income"
Client1: sum[Gross income] - [commission]
Client2: sum[Gross income] - [commission]
Client3: sum[Gross income] - [commission]
Calculated Form field: "total net"
sum[net income]
Calculated Form Field: "tax"
sum[gross income]*0.05
and so on and so forth for many more fields... these could all be double checked before a button printed these as reports based on the form data.
Head office now say printed is no good, the info needs to be sent via email as excel spreadsheets - Problems are:
Trying to Output To results in all the totals calculated in the various forms going missing in excel.
Any form with no data errors on output, and halts all outputs, not just that one(frequently happens, a particular type of client will do nothing for a month)
The output format appears spurious, fields that are in the first column on the form suddenly appearing 4th or 5th
As you may be able to tell from my explanation I've got a bit rusty, haven't a clue on the best way to achieve the goal! Any assistance much appreciated
e.g.
Table Field: "Gross income"
Client1: 20
Client2: 30
Client3: 10
Table Field: "Commission"
Client1: 2
Client2: 4
Client3: 3
Calculated Form field: "net income"
Client1: sum[Gross income] - [commission]
Client2: sum[Gross income] - [commission]
Client3: sum[Gross income] - [commission]
Calculated Form field: "total net"
sum[net income]
Calculated Form Field: "tax"
sum[gross income]*0.05
and so on and so forth for many more fields... these could all be double checked before a button printed these as reports based on the form data.
Head office now say printed is no good, the info needs to be sent via email as excel spreadsheets - Problems are:
Trying to Output To results in all the totals calculated in the various forms going missing in excel.
Any form with no data errors on output, and halts all outputs, not just that one(frequently happens, a particular type of client will do nothing for a month)
The output format appears spurious, fields that are in the first column on the form suddenly appearing 4th or 5th
As you may be able to tell from my explanation I've got a bit rusty, haven't a clue on the best way to achieve the goal! Any assistance much appreciated
