can someone assist .i am trying to write a query which get input from a text box and query two related tables in access. my code is as below but i get an error message
sql1 = “SELECT sum (Statistics.Passed_On) as sum1 From”
sq1 = “sql1 & Hospital, Statistics where”
sql1 = “sql1 & Hospital.hospital=Statistics.Hospital & and & Hospital.Province=’Tata’ & and & disease=’Cancer’ & and & date between #1/1/2004# and #12/31/2004#”
i want the user to input the parameters from the textboxes
