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.
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 |
|
|
|
|