Hello,
I've got an Excel Query pulling data from an Access database. But I need a way to only pull items with a "Next_Due_Date" date of "<=NOW()" and a "Status" of "1".
However, "<=NOW()" is not allowed, I get a syntax error. It seems it only wants to use static values.
Any suggestions?
Thanks =D
I've got an Excel Query pulling data from an Access database. But I need a way to only pull items with a "Next_Due_Date" date of "<=NOW()" and a "Status" of "1".
However, "<=NOW()" is not allowed, I get a syntax error. It seems it only wants to use static values.
Any suggestions?
Thanks =D