Search results

I have three tables (Customer, Order, CD's) I would like to know if it is possible to run a query that finds which customer has ordered the most Cd's? I have tried the following in an access query: FirstName TBL_Customer Group by OrderNumber(text) TBL_Order Max And i have tried FirstName...

Hi, I want to display all orders made between specified months that a user chooses, so for example say i want to check for all orders between January and March how would i do this in my query? My date field is set to shortdate I have tried the following: Month Names: Format([Order...

Hi could some one tell me if this is possible? I have a report that display fields based on a query. What i want is for the report to also include the words "Fantastic Choice" if the query returns "F" in the choice type field?

Hi can anyone tell me how i can create a report that displays for records per page? Thanks in advance

I need to build a database from scratch. Without hiding anything, i am a teacher teaching databases to students. I have been given some pre release materials containg a scenario. I have an ok level of access however i have problems interprating scenarios into databases. Please don't get me...

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...

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?

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...

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 Can anyone suggest a method for doing what the title asks. I basically have a single table with several fields. One of the fields is the length of music tracks in seconds. What i want to do is to set criteria so that when a query is run the records to not add up to more than 900 seconds...