Query date prompt in excel

Have a MS Excel 2003 query that works tied to an excel spreadhseet. Want to know how I can have it ask in excel for a date, where the date will go into the query. Like a prompt asking through date: ???? and you can enter the date, or even if a way you could make the query search automatically enter the current date into that field would work as well. So far this is my query in sql format.

SELECT PO01A.POHIS_PO_NO, PO01A.POHIS_LINE_ITEM_NO, PO01A.POHIS_SUPP_NO, PO01A.POHIS_DATE_ISSUE, PO01A.POHIS_QTY_ORD, PO01A.POHIS_AMT_ORD, PO01A.POHIS_QTY_INV, PO01A.POHIS_AMT_INV, PO01A.POHIS_INV_ITEM_NO, PO01A.POHIS_DESC_1, PO01A.POHIS_JOB, PO01A.POHIS_PHASE, PO01A.POHIS_DATE_REQD, PO01A.POHIS_BUYER, PO01A.POHIS_COMPL_SW
FROM PO01A PO01A
WHERE (PO01A.POHIS_COMPL_SW='N')

Questions by pamschertz

 

This Question is not yet answered!

 
 

Related Answered Questions

 

Related Open Questions