Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 General Structure

Author  Topic 

winstonsmith6076
Starting Member

4 Posts

Posted - 2014-07-23 : 16:09:59
I am developing an Access database to collect data from 10 spreadsheets that are exactly the same of time sheet data. Each spreadsheet has 40 rows and 10 columns. To accomplish this, I am linking to the 10 tables.

Once the data is put into one table, I am looking to join to 4 columns of employee data. To accomplish this, I am joining to the 10 tables in query called ConsolidatedData.

I then need to perform calculations on some of the fields. I am using the query results to make these calculations. I'm calling the resultant table CalculationTable.

Couple of questions. Is it proper to use query results for another query, and should I be stringing the queries together?

When I run the calculations in for the CalculationTable, the name of some of the fields switches to Exprxxx. Is that normal?

Thanks for your answers in advance.

When I run my calcuation



Winston Smith 6076
   

- Advertisement -