02-11-2002, 07:13 PM
i hope i helped a little even though i was a little late, query is the way to go
Open a query in Design view
In the Database window, click Queries under Objects.
Click the query you want to open, and then click Design on the Database window toolbar.
Notes
If a form, report, or data access page is based on a query, you can open the query to modify its design directly from the form, report, or data access page. For more information, click .
If you previously saved a query while it was displayed in SQL view, that's the view Microsoft Access displays the next time you click Design on the Database window toolbar for that query.
Edited By NaughtyAngel on Feb. 11 2002 at 2:14
Open a query in Design view
In the Database window, click Queries under Objects.
Click the query you want to open, and then click Design on the Database window toolbar.
Notes
If a form, report, or data access page is based on a query, you can open the query to modify its design directly from the form, report, or data access page. For more information, click .
If you previously saved a query while it was displayed in SQL view, that's the view Microsoft Access displays the next time you click Design on the Database window toolbar for that query.
Edited By NaughtyAngel on Feb. 11 2002 at 2:14
<center>Angel On The Outside
Naughty On The Inside
![[Image: CDIHC.jpg]](http://wnewsgirl.homestead.com/files/CDIHC.jpg)
You Gotta Rub Me The Right Way
Naughty On The Inside
You Gotta Rub Me The Right Way