Urgent Help Required!!!!!!!

[Makavali]

i have this one query to do in database and i could not figure out how to do that, first of all the question is The databasemust have the ability of producing (on demand) reports on current sales figures, such reports shell provide valuable statistical information on the number of items sold for each product (up to a period of one year). that was the questions and i need to find out the sales figures and the tables i have are CUSTOMER, ORDER, EMPLOYEES, PRODUCTS, SUPPLIERS, there are the tables and what formula or methods do i need to use in query to get the sales figures

Cheers

I hope u all will try ur best to solve this matter

[BlueIce]

Might help if we knew what database, system, op system you are using

[Makavali]

what u mean blue ice member, i am using Microsoft Access Database and i using AMD system.

[cowboybooter]

I'm not sure I understand the question, Makavali, but have you tried comparing your query to the northwind demo database in Access ?



CBB

[vass0922]

Shouldn't double post btw
http://www.techimo.com/forum/t62555.html

From the Forum Faqs

To facilitate the best response to your topic, and to aid in search compatibility, please make the title of your topic subject descriptive as to its relevant content. To avoid confusion and redundancy, do not multiple post your topic in the same forum or to other forums. More than one post on the same topic fosters confusion and is frustrating to those helping to provide solutions and troubleshooting history is broken and difficult to follow. Post your topic once only in the most appropriate forum for the subject matter. Duplicates of posts will be deleted or locked (no further replies are allowed) without prior notice.

Welcome to TechIMO. Please read the Forum Rules and familiarize yourself on the proper posting techniques. This thread is now closed.

surreal

Moderator.