using a variable in an Access Query

[braddog]

Thank you. I also had to wrap the date in # symbols to make it work:

str sd.time(d "MM/dd/yyyy")
str sdTemp.from("#" sd)
sd.from(sdTemp "#")

str sql.format("SELECT ALT FROM Table1 WHERE Date = %s" sd)