Anthony
I think you are looking for a parameter query...check here (Copy both lines
to browser)
http://www.nickhodge.co.uk/gui/datamenu/dataexamples/externaldataexamples.htm#Using_Parameters_In_External_ODBC_Data_Queries
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT[ at ]zen.co.uk.ANDTHIS
www.nickhodge.co.uk
"Antony" <Antony[ at ]discussions.microsoft.com> wrote in message
news:1ACBA68B-4F78-4B4C-9CAB-28AB08BA391B[ at ]microsoft.com...
[Quoted Text] >I have a sheet in Excel that i'd like to use MS Query to report all row
>that
> have a date in a certain column that is equal to or less than todays date.
> It's easy to select the relevant rows from a fixed date - but can anyone
> help
> with selecting using a changing date?
|