4 Different Parameters one Macro

[chris11590]

it takes 4 different parameters( branches =" incident commander and staff", "planning", "fire", "hazmat" ). is there a macro or VBA coding so that the front end user doesnt not have to input every parameters-for the most part the parameter hardly vary.

i needed to group the branches which breakdown to various group sectors and i did this grouping by a sql "where" in a query which has the parameter, "branch".

i attached the db

any help???

sorry posted twice. initally i posted in the wrong place.

chrissy

 

[apr pillai]

Create a separate Table with one field say BRN for Branch and Name the Table as Branch_Parameter. Save all four parameter values into the table as separate Records in BRN Field. Write your SQL as below:

SELECT tbleBranch.Branch, tbleGroupSector.GRPSector
FROM tbleBranch INNER JOIN tbleGroupSector ON tbleBranch.BranchID = tbleGroupSector.BranchID
WHERE (((tbleBranch.Branch) In (SELECT BRN FROM Branch_Parameter)));