Pulling together data

  • Thread starter Thread starter Scruff57
  • Start date Start date
S

Scruff57

I am trying to compile date from several Excel spreadsheets into Access. These spreadsheets include some performance metrics for individual employees as well as a lot of other useless information. I have the data imported into separate tables. The problem is there is no standard format for the spreadsheets and consequently the table data: some are dated with the week starting date, others are individual dates; some are by employee name others employee id. I have a table that links the name with id and supervisor. I am trying to get a query set up so a supervisor can enter a date range and get summary data for each of their employees over that date range for all of the different metrics. I may also want to have a field calculated from the other data in the table, but not sure whether to have it in the query or the report.
Do I need to include the date field from each table in the query, if not, does it matter which date field I query on?
What is the best way to accomplish this query - collect all the data into one query, or to calculate the results in the individual query and run a separate query on the calculated results?
 
What is the best way to accomplish this query - collect all the data into one query, or to calculate the results in the individual query and run a separate query on the calculated results?
Click to expand...

I'd go through the labor of getting all the data into a single table
in a consistant field layout. You'll never be able to get consistant
queries on inconsistant data!

A single query will then be much simpler, and would probably be
preferable in any case.
 
Back
Top