P
Peter Reefman
I'm trying to obtain a record from a database table based
on proximity to today's date, and have used NOW() or DATE
() in other queries in other products such as SQL Server
Query Analyser, but have come up short on how to put a
parameter such as Now() into the Value for the criteria on
the Date Field selected in the MS-Query Design process.
I'll be using this to feed back into a cell in an Excel
Spreadsheet Template which will in turn be used in another
data query. I need this single query to replace a vlookup
function on a period end dates Named Range that needs to
be revised each financial year, which probably won't get
done if I'm not there to do it!
Seems simple, but there doesn't seem to be any docco out
there on anything like this.
on proximity to today's date, and have used NOW() or DATE
() in other queries in other products such as SQL Server
Query Analyser, but have come up short on how to put a
parameter such as Now() into the Value for the criteria on
the Date Field selected in the MS-Query Design process.
I'll be using this to feed back into a cell in an Excel
Spreadsheet Template which will in turn be used in another
data query. I need this single query to replace a vlookup
function on a period end dates Named Range that needs to
be revised each financial year, which probably won't get
done if I'm not there to do it!
Seems simple, but there doesn't seem to be any docco out
there on anything like this.