Unanswered: can anyone verify my sql behind a form
Ok, I am using following version. I don't want to put all the fields in sql (table.field1, table.field2). Instead, I want to feed two field (txtYear and cboAdmin) from the form to the query (qryindividual1 for txtyear and qryindividual2 for cboadmin) and let the query run.
I am using following query but this time i get a error. "The select statement includes a reserve word or an argument name that is mispelled or missing, or the punctuation is incorrect."
Please let me know where is the problem.
Thanks / Dianna
I am getting "Object Required" error. Also, it's not keeping my qryindividual2 in orignal shape. It's deleting everying from that query. Your help will be very much appreciated. I have been struggling for days.