Microsoft Office Tutorials and References
In Depth Information
Passing Your Own SQL Statements to External Databases
Figure 18-20: Add a command button and assign your newly created RefreshQuery macro.
If all goes smoothly, you’ll have a nifty mechanism that allows dynamic extraction of data from your
external database based on the criteria you specified (see Figure 18-21).
Figure 18-21: You now have an easy-to-use mechanism to pull external data for a specified market.