Paramaterised Query to Report

  • Thread starter Thread starter qqqq
  • Start date Start date
Q

qqqq

Hi

Is it possible and if so how do I do the following:

Produce a form with combo boxes.

Use the values from the combo boxes to send parameters to a query (ADP using
SQL Server) - this bit I am ok with.

Then to return the results of the query to a report.

Thanks in anticipation.

Regards

Geoff
 
You could create a form with combo boxes for your report and link the query
that is the record source of your report to that form, access help has some
examples, the criteria for your query will look like Dated =
[Forms]![Parameter_frm]![Dated], check www.joshdev.com, there is a tools set
that may help

JL5000
 
Thanks JL5000 I'll try that
jl5000 said:
You could create a form with combo boxes for your report and link the query
that is the record source of your report to that form, access help has some
examples, the criteria for your query will look like Dated =
[Forms]![Parameter_frm]![Dated], check www.joshdev.com, there is a tools set
that may help

JL5000


qqqq said:
Hi

Is it possible and if so how do I do the following:

Produce a form with combo boxes.

Use the values from the combo boxes to send parameters to a query (ADP using
SQL Server) - this bit I am ok with.

Then to return the results of the query to a report.

Thanks in anticipation.

Regards

Geoff
Click to expand...
Click to expand...
 
Back
Top