prompt for date range

[kathyc20]

I am writing a query where I need to prompt the user for a start date and an end date.

Can someone please point me in the direction on how to do this?

Thank you

 

[fredericofonseca]

what language are you using to execute the SQL statement?



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[mncprogrammer]

I am using a SQL Query with excel to create data based on date criteria. It works fine. It displays a box with
"ENTER PARAMETER VALUE" start date and repeats another box for end date.

Maybe someone could suggest how to edit the box for more descriptive info requirements.

Query Logic:

select *
from shiptable

where (shiptable.ShipDate Between ? And ?)

Hopes this helps!

Gary