I have a query in MS-Access which when run prompts for a parameter and then copies data from TableA to A Temp Table. As I need the Query to run more than once how do I pass a parameter once or how do I do this using code?
Thanks
Brian