Search results

Thanks! I'll give that a try

Aah but these are just practice files, to familiarise our selves with content. the real work will be given to us through an exam. I am just experimenting with the options at the moment. So my academic achievements will be my own seeing as though i will learn from you experts!

Yes this is a school project, why do you ask?

any one got any suggestions?

I'll make it no secrect that i have been given the data as a csv file i was meant to extract relevant data out into additional tables, once i have done that i have to perform the analysis. There is no specific requirement. So how do you create some of those queries tha you mentioned such as...

I have a databse that i want to perform some analysis on to identify some trends. The database consists of album sales of a year. I have availble all details of orders, customers and albums. All tbales are joined with one to many relationships. Can anyone suggest some queries that i could do to...

Its ok please ignore as i have solved this by doing a group by count.!:)

I have a Database that contains a number Albums and Artists. I also have a table that contains orders from customers for these albms. Basically i want to track which album and artist is bought most? Can any one help?

Thanks for all your replys guys that helps me make more sense of it.

Thanks Brian, Would you mind if i asked you how you know that? And what do the "4" and the "2" represent?

Month Number: Mid([Date],4,2) I also have the SQL that goes with the query: SELECT Mid([Date],4,2) AS [Month Number], Count(tblOrders.Order_Number) AS CountOfOrders, Sum(tblBikes.Price) AS SumOfPrice, Format([Date],"mmmm") AS [Month Name] FROM tblOrders INNER JOIN (tblBikes INNER JOIN...

You Sir are a genius!!! Thanks that works a treat!

Hi, I have several tables that i have joined with relationships. I would like to perform some analysis on the sales. I want to create a query that displays monthly sales, but istead of the date being displayed as, i.e: 2/02/2007 i would like the date to show only the month name i.e. February...

Hi I have some tables that i would like to perform some queries on. I have a product table that is linked to an orders table. I would like to calculate the number of products sold in a particular month and also the total income generated from the sales. Can some one advise how I could do this...

Hi i still have not managed to resolve this can anyone help?

Yes thats what i want to do. Is it possible? I can change the length field type to number, silly me!

Hi wayne, I was replacing Track with Length. I'll attach my table structure here if thats ok.

I was putting in >< 900 Now that i have changed it i get prompted by a dialogue box asking for values to enter into track1, track2, and track3 and then nothing is displayed in the query result :confused:

"And in the criteria, put --> < 900" I get an error message when i put that into criteria: The expression you entered contains invalid syntax You may have entered a comma without a preceeding value or identifier

Hi wayne, Thanks for your reply. The Track times are all in one table if thats what you meant, unfortunatley i was given the data like this. I'll give your 1st suggestion a try and get back to you. Thanks again.