Jim-
Do the calculations simply involve applying formulas to columns in the imported data? If so, why not do the calculations in a query when needed or in Excel? What sort of analysis do you plan to do in Excel? Unless you need some complex financial functions, it might be best to do your "analysis" in Access with a report. Use the right tool for the job.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jan 20, 2015, at 3:28 AM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Bob,
The calculations are in the query and then appended to the table. That is what is in my head at this point. I have created a query with some calculations but have not even converted the select query to an append query.
I have a downloaded table every day. I would like to capture the calculations for the various metrics and then have the append query add the calculated values in the query to the table based on the date. Then I was going to do the analysis on the table in Excel. This is what I have in my head.
Jim Wagner
On Friday, January 16, 2015 2:40 AM, "'Bob Phillips' bob.phillips@dsl.pipex.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
I have to ask, why would you add totals to the table? That is a no-no surely, totals should be calculated in the query so that you always include all of the latest data.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: 15 January 2015 23:27
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Data Analysis question
Sent: 15 January 2015 23:27
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Data Analysis question
So I have a question that I have been working on a solution for 2 days and I am unable to come up with a way to accomplish this. We would like to do some analysis for some data that we download every day. I would like to have the totals for each metrics appended to a table each day for a week from the current download each day. there are 4 campuses and 20 departments and we would like to track things like
Gender
FTE like .25%, .50% etc
Employee status
Race
Grade
Full or part time
I figure that we could use Excel to do the analysis but my issue is how do I get to append the data each day from the new table download?
Jim Wagner
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar