michaelfairburn
Registered User.
- Local time
- Today, 14:56
- Joined
- Feb 8, 2010
- Messages
- 13
Hello All,
I am stuck! I have a linked Excel table in which there are over 100 rows and 60 columns. Each of the rows represents a project and each of the columns represents an attribute of that project.
My problem is this: Each row has details of 6 governance 'gates'. Each 'gate' has 3 date options - initial, revised and actual. I want to run a query on the data that will tell me which project is coming up to a gate and which gate it is. If it's already been through a gate it will have its 'actual' date filled in, obviously.
I need to be able to produce a report for eventual mail merging to send to the project managers to remind them that they're coming up to a gate and to book them into the appropriate gate forum.
I have absolutely no idea how to get ONLY the gates with approaching dates out of the data. I can easily get the whole record out if one of the dates happens to be within a certain parameter (>Now() AND <=Now()+14), using the OR function for each of the gate, but that gives me every gate date, the one I want and the ones I don't.
I probable haven't explained this very well, so please feel free to ask questions. Any help you can give me would be gratefully received as I'm rapidly tearing out what little hair I have left!
I am stuck! I have a linked Excel table in which there are over 100 rows and 60 columns. Each of the rows represents a project and each of the columns represents an attribute of that project.
My problem is this: Each row has details of 6 governance 'gates'. Each 'gate' has 3 date options - initial, revised and actual. I want to run a query on the data that will tell me which project is coming up to a gate and which gate it is. If it's already been through a gate it will have its 'actual' date filled in, obviously.
I need to be able to produce a report for eventual mail merging to send to the project managers to remind them that they're coming up to a gate and to book them into the appropriate gate forum.
I have absolutely no idea how to get ONLY the gates with approaching dates out of the data. I can easily get the whole record out if one of the dates happens to be within a certain parameter (>Now() AND <=Now()+14), using the OR function for each of the gate, but that gives me every gate date, the one I want and the ones I don't.
I probable haven't explained this very well, so please feel free to ask questions. Any help you can give me would be gratefully received as I'm rapidly tearing out what little hair I have left!