Append query - cementing in parameters

[jtkjames]

Basically I have an append query, which takes data from a series of sub queries to append to a table. The sub queries are also used elsewhere in the database and have parameters.

What I would like to do (if it is possible) is to have the append query use a "preset" fixed value for the parameters requested by the sub queries, rather than ask the user upon execution.

The long winded way of doing this is to copy and paste all sub queries then remove / set the parameters individually.

The problem with this method, in my database, is that it would be extremely time consuming however - as the append query has a union query as its sub, which unions three other queries, each having five sub queries in them, each of those sub queries are quite complicated and have the parameters.

So this method would involve

1x3x5x4 copy and pastes and modifications.

Can anyone suggest a better way to do things? I was kind of hoping I could modify the Append Query SQL to include a set value for the parameters requested by its various subs, but a search of google and this forum doesn't appear to offer any hints in the right direction...

Thanks!

 

[Galaxiom]

Make a table with all your parameters as fieldnames and enter the values as a single record.

Join the table to the others in the From clause of the queries.

 

[jtkjames]

Make a table with all your parameters as fieldnames and enter the values as a single record.

Join the table to the others in the From clause of the queries.

Legendary thanks!