Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query

Status
Not open for further replies.

glenmcgregor

IS-IT--Management
Dec 14, 2001
14
GB
I have little knowledge of databases and need a bit of help. I have imported data into Access and there are four fields <supplier><style><quantity><price>.

For each style which is unique there may be price variations over a period of time. I need to rationalise the data to only give me the styles that have more than one price in the data and return that in a report.

Can anyone please help?
 
dear glenn,

you create a query (source is your table) counting the records grouped by style.

you create a second query (source is your table and the first query)
in that query you link the style from the query with the style from the table.

HTH regards Astrid
 
Astrid

I am not sure that I follow you - sorry. I have created a query based on the table. When I create another query based on the table and the first query I get &quot;You have chosen fields from record sources which the wizard cant connect etc.............&quot;
 
dear glen,

it is the wizard!
Create the second query base on yor first query.
Save it.
go to edit mode:
right click where the used tables are displayed and choose
&quot;show Tables&quot; then add your table. and do the connection.

(sorry I have a german Version so don't rely on exact names)

regards Astrid

BTW I never use the wizard :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top