如何计算访问量的每月销售额? [英] How do I calculate monthly sales in access?

问题描述

我正在建立一个数据库，供一家销售窗帘，百叶窗，靠垫和各种其他产品的小企业使用.我需要为每种产品制作月度报告，但是我不确定如何去做.到目前为止，我已经进行了查询，以通过将数量乘以单价来计算订单的总价.

到目前为止，我拥有的表和查询是:

客户表:

Hi, I''m making a database in access for a small business that sells curtains, blinds, cushions and various other products. I need to make monthly reports for each product, however i''m not sure how I would go about doing this. So far I have made a query for calculating the total price of an order by mutltiplying the quantity by the unit price.

The tables and queries I have so far are:

Customer table:

Customer ID (PK)
First Name
Last Name 
Age
etc

产品表:

Product Table:

Product ID (PK)
Name
Type
Size 
Unit Price

订购表:

Order Table:

Order ID (PK)
Order Date
Customer ID (FK)

订单明细表:

Order Details Table:

Order Details ID (PK)
Order ID (FK)
Product ID (FK)
Quantity

订单价格查询:

Order Prices Query:

Quantity
Name 
Unit Price
"Total Price"
Product ID
Order ID

推荐答案

希望这可能对您有所帮助

http://www.youtube.com/watch?v=i72sqEBBALs [

hope this may help you

http://www.youtube.com/watch?v=i72sqEBBALs[^]

这篇关于如何计算访问量的每月销售额?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！