Parameter Queries, ignore other one

[fordy]

Is there anyway you can link parameter queries, so it doesnt ask for the same information twice

SELECT Avg([F COST]) AS AvgOfCost
FROM [T_IN SURVEY]
WHERE ((([T_IN SURVEY].[F EST LIFE]) Between 0 And 6) And (([T_IN SURVEY].[PROPERTY GROUP])=[House]));

next

SELECT Avg([R COST]) AS AvgOfCost
FROM [T_IN SURVEY]
WHERE ((([T_IN SURVEY].[R EST LIFE]) Between 0 And 6) AND (([T_IN SURVEY].[PROPERTY GROUP]) Like [House]));

House and House for example

 

[Rich]

Use a custom built form to enter value required, reference the form and value in the criteria