View Single Post
Old October 17th, 2003, 10:44 PM
sal sal is offline
Friend of Wrox
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts

You are welcome,
Click on Queries,
Click on "New" on top
Click "OK" when the "New Query" dialog opens
Close the "Show Tables" dialog when it opens
                  On the top left of your screen you will see "SQL" in Bold letters, click on that and a screen will open and it will have the word "SELECT;" entered. Delete it and paste the code I gave you.
Replace every T1 for the name of your table in your database.
open your query and you should see the results.
after that you can open your query in design view as normal and you can add the remaining fields that you wish to show.

that's it.
time to go to bed, too bad you are working on Saturday.