hi all, i have problem creating queries in access.this is because i do not know how to call the value from a variable in vb into the query in access.
let say in vb i've created :
Public booking_date As Date Public fac_type As Integer . . . . booking_date = MonthView1.value fac_type = Combo1.ItemData
i suppose to have a query done in access which i will call in vb
SELECT TF.time_id FROM TF WHERE (((TF.fac_id)="fac_type") AND ((TF.reserv_date)="booking_date"));
how do i accomplish this?please help!
thanx in advnce!