slam69
asked on
Passthrough not passing through
Hi,
I want to ensure my processing is done one sql server as large table, I need to have a date range variable passed to the server to complete the select statement.
if i substitute the variable forms for real dates it works fine i just need to know how i can get the values in the two combox boxes to be put into the query.
please help as im guessing if i just design this as a regular query in access the whole delivery details table will be feteched and the processing done on the client
I want to ensure my processing is done one sql server as large table, I need to have a date range variable passed to the server to complete the select statement.
if i substitute the variable forms for real dates it works fine i just need to know how i can get the values in the two combox boxes to be put into the query.
please help as im guessing if i just design this as a regular query in access the whole delivery details table will be feteched and the processing done on the client
select patient_name, ship_to, Unit, Treatment, delivery_date, datename(day,delivery_date) as day, special_reason, Delivery_not_required, Quantity_required
From TBL_Delivery_details
Where (Delivery_date between ([forms!FRM_input for passthrough!combo3!]) And ([forms!FRM_input for passthrough!combo5]))
And Delivery_not_required = 0
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
all sorted now
>im struggling with the connection string ;oS
Give this a whirl...
http://www.connectionstrings.com
Thanks for the grade. Good luck with your project. -Jim
Give this a whirl...
http://www.connectionstrings.com
Thanks for the grade. Good luck with your project. -Jim
ASKER