Insert parameters directly into SQL query

[markspraggins]

I have the following SQL query:

SELECT "TransHeaders"."Logged", "Branches"."Name", "Departments"."Description", "TransLines"."Quantity", "TransLines"."SubBeforeTax", "TransLines"."SubAfterTax", "TransLines"."TransNo", "TransHeaders"."TransStatus"
FROM ((("AKPOS"."dbo"."TransLines" "TransLines" LEFT OUTER JOIN "AKPOS"."dbo"."TransHeaders" "TransHeaders" ON (("TransLines"."TransNo"="TransHeaders"."TransNo") AND ("TransLines"."Branch"="TransHeaders"."Branch")) AND ("TransLines"."Station"="TransHeaders"."Station")) LEFT OUTER JOIN "AKPOS"."dbo"."Branches" "Branches" ON "TransLines"."Branch"="Branches"."ID") LEFT OUTER JOIN "AKPOS"."dbo"."Items" "Items" ON "TransLines"."UPC"="Items"."UPC") LEFT OUTER JOIN "AKPOS"."dbo"."Departments" "Departments" ON "Items"."Department"="Departments"."ID"
WHERE "TransHeaders"."TransStatus"<>'V' AND ("TransHeaders"."Logged">={ts '2011-01-01 00:00:00'} AND "TransHeaders"."Logged"<{ts '2011-01-16 00:00:00'})
ORDER BY "Branches"."Name", "Departments"."Description"

where the date fields (in red) need to vary. I want to reference to cells B1 and B3 on a worksheet called "dates" which I can then change to suit.

I am only used to using the graphical interface so would appreciate help!

Thanks