SinnaminGrrl
Board Regular
- Joined
- Feb 21, 2006
- Messages
- 65
I searched the forum and saw several posts to this effect, but nothing quite had the detail or scenario I am faced with.
I have a data dump that I get daily in excel.
There are several columns I need to create a new report out of but I also am finding myself needing to do the same manual calculations in Excel every day. I thought this could be solved nice n easy with access to do the "calculatin'" for me.
The problem is I don't know how to do all these multiple queries because some of the work I need to do is based on the result of a calculated field/query.
Here's the details:
I get the data dump as such:
<tbody>
</tbody><strike></strike>
The calculations I do in excel are first a "mid" to extract XX and YY (for example) from the computer name. That gives me a "Computer Type", based on computer type I do another lookup to get the state of the machine. Then further I need a separate lookukp on the domain to get a country code.
So, I started in Access by creating a query to get my "computer type".. .. now how do I query on the results of that query?...I hope this makes sense.
I have a data dump that I get daily in excel.
There are several columns I need to create a new report out of but I also am finding myself needing to do the same manual calculations in Excel every day. I thought this could be solved nice n easy with access to do the "calculatin'" for me.
The problem is I don't know how to do all these multiple queries because some of the work I need to do is based on the result of a calculated field/query.
Here's the details:
I get the data dump as such:
Issue | ComputerName | Domain | ComputerType | State | Countrycode |
K222222 | 12345678XX123 | xyz.com | =mid(A2,8,2) | =vlookup(based on computer type) | =vlookup(based on domain) |
K333333 | 87654321YY321 | zyx.com | =mid(A2,8,2) |
<tbody>
</tbody>
The calculations I do in excel are first a "mid" to extract XX and YY (for example) from the computer name. That gives me a "Computer Type", based on computer type I do another lookup to get the state of the machine. Then further I need a separate lookukp on the domain to get a country code.
So, I started in Access by creating a query to get my "computer type".. .. now how do I query on the results of that query?...I hope this makes sense.