> MyQry.SQL = "select * from reports
>
([Adviser_ID.Text],[Provider_ID.Text],[Introducer_ID.Text],[PlanGroup_ID.Text],[PlanType_ID.Text],[DateSpecific_Start.Text],[DateSpecific_End.Text],
> Child24.Form.CurrentRecord , Child26.Form.CurrentRecord) as
> (employee_first_name varchar,employee_last_name varchar,date_issued
> date,client_first_name varchar,client_middle_names varchar,client_surname
> varchar,tblplantypes.plantype_group varchar,plangroups.plangroups_groupvarchar,
> tblproviders.provider_company varchar,policy_number varchar,sum_assured
> numeric,benefit varchar, premium numeric,brokerage numeric, comments text);"
I think I see your problem here. You still need to parse you sql strings with &.
So where ever you need to pass a integer it must be passed like:
"select * from reports (" & [adviser_ID.text] & ", .... " -- for integer parameters and
",'" & [dateSpecific_end.Text] & "', .... " -- for string parameters.
This link http://www.fontstuff.com/access/acctut20.htm show how to incorporate Access controls
into the sql string.
Regards,
Richard Broersma Jr.