B
Bob
We have our school records in an in-house designed Access
2000 database. We need to "crunch" a lot of our numbers
that are stored in various table fields.
Many of the functions (sum, average, etc) we can do by
using the functions in queries. However median is much
more difficult. The median function in Excel is much
easier however. For example, if I had an Access table
with the three fields: Student Name, Home Room, and Test
Score. I could use the DSum or DAverage function in
Access to find totals and averages for the respective Home
Room. But I'd have to work fairly hard to get a median.
Where as in Excel it would be very simple.
Is there a way that we can write a macro (or some other
means) that would automatically export data to Excel, let
it crunch the numbers, and import it back to be place on a
report. That is, can we link a query column to an Excel
spreadsheet so that we might use the functions of Excel
and then use the results in an Access report.
Thanks for your help,
2000 database. We need to "crunch" a lot of our numbers
that are stored in various table fields.
Many of the functions (sum, average, etc) we can do by
using the functions in queries. However median is much
more difficult. The median function in Excel is much
easier however. For example, if I had an Access table
with the three fields: Student Name, Home Room, and Test
Score. I could use the DSum or DAverage function in
Access to find totals and averages for the respective Home
Room. But I'd have to work fairly hard to get a median.
Where as in Excel it would be very simple.
Is there a way that we can write a macro (or some other
means) that would automatically export data to Excel, let
it crunch the numbers, and import it back to be place on a
report. That is, can we link a query column to an Excel
spreadsheet so that we might use the functions of Excel
and then use the results in an Access report.
Thanks for your help,