I don't see columns from a data source

  • Thread starter Thread starter Lore
  • Start date Start date
L

Lore

I am new with querys!!!

What I am trying to do is:
1. I have a work sheet with all the information of products with costs (and
other information that has to do with the cost calculation), descriptions,
measurements, and retail prices.
2. I want to make a "Price list" for the public with just the final price
and some
columns that have the description, and Product ID and measurements.

I am trying to create a new query (which will be the "Price List") from an
excel work sheet (which is my data source with all the information of the
products).

I follow all the steps to create a new query, but either I get only one
column with one item or no columns at all, so I cannot select the colums
that I need to include in my Price List.
Do I need to set up my work sheet (data source) in a certain way so when I
create a query it works properly? Or...what is it that Iam doing wrong?

Heeeeelp please!!

Lore D.
 
I don't know what a query is, but it sounds like a data sort which i do know
what is.
To data sort, open spreadsheet and hit control plus A, that will light up
everything.
Then click data on the top row, then sort.
Pick what you want from the pop up menu, and do the sort.
Then you can either delete what you don't want,
or copy what you do want.

Avery
 
Back
Top