sql coding on access 2007 reports

  • Thread starter Thread starter Ali DEĞİRMEN
  • Start date Start date
A

Ali DEĞİRMEN

hi,
i want to learn writing sql codes on reports (ex. control source) i'm taking
the datas form an order form and i want to select another column using the id
value coming form the form.after all i want to write it to report(textbox).

i'm think it will be like this but its not work.
select from contact.telephones where id = orderform.companyname
 
You do not use SQL to get data from forms. SQL is used only for tables and
queries.
If you want to get the value from a form control in a text box on your
report, it is:
=Forms!orderform!companyname
 
i see but i want to get (for examples the call numbers on the same row )
using company name or company id (variable of the form)
 
Back
Top