In a query, how do I get two Items off of a table of 13?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having trouble just puting two items into a qurey without having the
other information on the qurey. Could someone explain how I do that.
 
When you build the query, you would ass the table to the query, then you'd
grab the fields you wnat and drag them onto the lower section of the query.
One column per field you'd like to pull.

What's down there now? If you have all the fields down there, jsut delete
the ones you don't need.
 
Make sure that you don't have the Output All Fields property set to yes.

Select View: Properties from the menu.
Click in the grey area of the grid
Check the properties for the query.

Alternatively,
Switch to the sql view (View: SQL view from the menu)
If there is an asterisk (*) in the SELECT statement along with a list of fields,
delete the asterisk.

SELECT FieldA, FieldB, * <---- Delete the *
FROM YourTable
 
Back
Top