Passing parameters to several queries

Hello,

I would like to pass the same several paramaters to multiple queries and reports. The parameters are the same for all reports and queries and only change every several weeks. I do not want the user to pass the parameters. Rather than change the criteria within each individual query and report, I have stored the parameter values in a table. Each query or report includes the parameter table. This works fine in one report where the remaining tables are joined with inner joins, and the parameter table is not joined to the other tables. However method does not work in a query that uses outer joins. The addition of the "unjoined" parameter table results in a SQL error.

Is this an acceptable method of passing parameters to several queries? Can you suggest a solution to my problem, or a better method of passing parameters?

Thank you

Bob-

Bob,

There are several ways to do this, but from your post what I would suggest is to make a form bound to your table that has your parameters listed in. Then for each query and report set the parameters to this form using the associated fields. Depending on how you run each query or report, open this form in the hidden view before running the query or report to pass the parameters. You can change the parameter criteria in the table as needed and the queries and reports will change to the new criteria you entered.

lwells

Hi,

I have a simple suggestion that might come in handy in passing parameters to your query. First, you must use relationship table like for example [title] from book table is related to [title] from author table. Be sure that they both have the same data type.

Once you have the link between this two tables, book table and author table. You can create a joint query using book table and author table wherein your [author field] from author table can be displayed based on your [title field] from book table.

In reports, you can also use the query like [Enter Author] your criteria in author field of your author table, then in report header page. In this example, insert this ="Author name " & [Enter Author] this will concatenate the text "Author name" and [your parameter]

Tim

lwells,

I came across this forum and I was looking for some sample codes of a Form that pass a parameters to a reports. I appreciate if you had some sample codes that you can provide.

Thanks,
Warren