GeekInterview.com
Series: Subject: Topic:
Question: 1 of 133

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')
Asked by: pamschertz | Member Since Jun-2011 | Asked on: Jun 15th, 2011

View all questions by pamschertz

This Question is not yet answered!

Related Open Questions

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.