Search results

Thanks JR, that worked a treat. Much appreciated :-)

I read the article Rich and I'll check out the database on Monday when I'm back at work. Thanks. Mike

Thanks Rich, but there isn't any vba in the database (or at least none that I've put in there)

Reference to what Rich? I just replaced the Now() with Date() in the SQL above. Mike

Hi Brian, I tired the date() and it didn't work. Maybe I did something wrong; I just changed now() to date(). Was that right? Mike

Thanks JANR, I'll try that. Mike

OK, so I've created 2 separate queries for 2 gates and they each give me the results I would expect. I have then joined the queries using the UNION command (see below) as suggested by Brian above. This ALMOST gives me the result I need EXCEPT that the column heading are those of the first query...

Thanks Brian. I thought I might have to end up with a whole bunch of queries. I'm not knowledgeable enough to do union queries; could anyone point me to a good site where I might learn how to do them? Thanks Mike

Thanks jdraw, I got that, but I don't know which fields I want until I work out which of them is valid. For example, one project may be coming up to the RFV gate, in which case either of these fields ( tblLinkedMasterData.[RFV Initial Date], tblLinkedMasterData.[RFV Revised Date]) could have a...

OK, so here's the SQL copied from the query: SELECT tblLinkedMasterData.[Project name], tblLinkedMasterData.[Segment Project manager name], tblLinkedMasterData.[PRP Initial Date], tblLinkedMasterData.[PRP Revised Date], tblLinkedMasterData.[RFD Initial Date], tblLinkedMasterData.[RFD Revised...

Thanks Dave, but I've managed to get that far. In fact, using the >Now() AND <=now()+14 type of parameter in each of the date fields (effectively using the OR command) I can get the [very large] query to pull out all those projects that have a gate coming up. The problem I have is that I don't...

Ha, I thought maybe I hadn't explained it very well :) So, I guess, this is what I'm looking for: FROM EACH Project, SELECT those dates from EACH GATE (of 6 gates) (with dates representing Initial, Revised, Actual for each gate) that correspond to a parameter and then show ONLY those dates...

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