Recent content by roadrage

It's a database ive put together as part of a course I'm delivering so the actual functionality of it needs to be limited, I'm just trying to identify some of the trends in data. Thanks so much for your help!

Thanks I'll try that

Customer table: Id title Name Address Credit card details Cd table: Id Cd number Cd title Artist Order table: Order number Order date Cust id Cd id Hope that's enough info.

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

That has worked! Thanks again to you guys!

I'm using the month function : MonthNum: Month([Order Date]) And my search criteria is: Between [Enter month 1] And [Enter month 2]

Hi, no I didn't get this fixed, my month comes from and orders table, the field type is set to short date? Do you have any ideas?

Thanks that works!

I also was wondering if it is possible to find out whether i can group my orders depending on the gender of the customer?

Hi, I noticed that if i enter month 1 and month 3 it shows month 12, 11 and 10.

Thanks for the reply that works just fine!

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

Thanks for your immediate replies, that works great thanks!!

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?

Sorry mods i don't know why this has appeared twice