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
Query date prompt in excel
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')
Profile Answers by pamschertz Questions by pamschertz
Questions by pamschertz
This Question is not yet answered!
Related Answered Questions
Related Open Questions