PDA

View Full Version : Access Question


Tom
10-12-2003, 09:25 PM
I have several tables in one db that are identical in structure, but have differnet tracks in each one.
I want to copy a querry I wrote in one to use in the others as well. The only difference in each will be the formulas for the speed and pace figures for the specifi track.
Is there a way to copy the vanilla querry but have it refer to a new table?

cj
10-12-2003, 10:08 PM
Tom,

Copy the query and rename it. Then, open the new query in design view. Add the table by right clicking in the open space next to the original table. Select "Show Table..." and add the new table. Then, just change the table in each of the drop down boxes next to table for each of the query parameters. Probably not as quick as you were hoping, but it should save you some time.

Tom
10-12-2003, 10:24 PM
Thanks, Craig.
:D