dwe0608
asked on
URGENT : Not good at math and need help working out averages - Crystal Reports
Have thought of a very easy way for this, using disconnected recordsets. Post code in a few minutes.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you must use Crystal Reps adabpt the section prepare outout to save the data into a tables for AgeBands and Profession results. Then create the report from the simple tables.
ASKER
I am giving this a try now, so far so good ...
You should not need to change much just field names used in the People recordset: "DOB" and "Prof" & the table name used in the select statement.
How did it go?
What you do is create some queries that provide the data you need. Then it is so simple:
1) Open Excell and create a Spreadsheet. Save the Sheet with the name you want.
Keep the sheet open
2) Open access, and create the queries you need.
(see the download sample that I will provide)
3) Right Click on a query and select copy.
Keep the database open.
4) Go back to Excel
Click on Edit, Paste Special, then Select Paste Link.
And now you have your data.
See next post for sample.