I would like to set up a macro in access that will locate a file, run a query on the file, and print out the result. I would like to link all these works to a key on the keypad so that when I hit on that key everything executes from the begining to printing. This will be used to print out lists of employees who are present in a facility during an emergency evacuation. Thanks for helping me!