Paramaterised Query to Report

[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

 

[Guest]

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]

Thanks JL5000 I'll try that

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

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