Search results

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

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

Its ok I managed to sort it. Thanks to everyone who helped out on this i really have come along way in databases.

Hi another question if i may :) I have a form that collects customer data. The form when runs a macro that inturn open two queries. The first query creates a new customer and the second updates a booking table. However my question is is there any way of getting the Customer id into the form...

Thanks for your help. I don't propose to boast to know about Access inside out, and i don't let my students believe this either, however every one has to learn somewhere as i'm sure you all did. With me i've never needed to deliver databases to such a level before and as its the first time i'm...

Thanks for your help....not!!