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
Where (Delivery_date between ([forms!FRM_input for passthrough!combo3!]) And ([forms!FRM_input for passthrough!combo5]))
And Delivery_not_required = 0