库存处理 [英] Stock Processing

问题描述

嗨学生2

我正在研究类似的股票计算方法，但即使将我的问题提交到不同的论坛后也无法找到解决问题的方法。

我看到你的帖子说你已经解决了库存计算的问题。

i也需要帮助。

我使用vb express和MsAccess作为数据库。

我正在尝试编写Stock的计算查询。

我的表格如下：

PurchaseTable（PTId，PDate，ItemId，描述，数量，价格，金额）

SalesTable（STId， SDate，ItemId，描述，数量，价格，数量）


我想要查询stockcalculation以显示数据在某个日期范围之间或任何给定日期之间：


ItemId，QuantityPurchased，QuantitySold，Balance（StockQuantity + QuantityPurchased - QuantitySold）


从你的主题我抓住了一些想法，我将不得不为StockQuantity作为开仓股票，以便可以添加到newstock购买。

请告诉我，如果你能给我这个问题的表格，你将会非常感激。

谢谢


**编辑**

从 Ms访问高级计算查询，库存水平？ ：S

解决方案

不要忘记在计算中考虑空值

如：

展开 | 选择 | Wrap | 行号

嗨Stevens

感谢您的回复和指导。

事实上，我需要帮助编写库存计算查询，因为我使用Vb express和MsAccess作为数据库。

我希望在Vb express中使用查询，该查询将在表格上工作并检索任何给定的库存余额日期。

请指教。

< blockquote> @ sazd1


什么是StockQuantity意思是说。购买和出售的东西？

Hi Student2
I am working on similar kind of thing for stock calculation but could not find any solution to my problem even after putting my problem to different forums.
I saw your post that you have solved this problem of stock calculation.
i need help for that too.
I am using vb express and MsAccess as database.
I am trying to write a query for the calculation of Stock.
My tables are as under:
PurchaseTable(PTId, PDate,ItemId, Description, Quantity, Price, Amount)
SalesTable(STId, SDate,ItemId, Description, Quantity, Price, Amount)

I want a query for stockcalculation to show data as under between some date range or at any given date:

ItemId, QuantityPurchased, QuantitySold, Balance(StockQuantity+QuantityPurchased - QuantitySold)

From your thread i grasped some idea that i will have to make a separate table for StockQuantity as opening stock so that it may be added to newstockpurchased.
Please advise me and if you could give me the query you are using with the tables for this issue it will be highly appreciable.
thanks

** Edit **
Split from Ms Access advanced calculation query, stock level? :S

解决方案

Dont forget to account for null values in your calculations
such as:

Expand|Select|Wrap|Line Numbers

Hi Stevens
Thanks for your reply and guidance.
Infact I need help to write a query for stock calculations as I am using Vb express and MsAccess as database.
I want a query to use in Vb express which will work on the tables and retrieve the balance of stock at any given date.
Please advise.

@sazd1
What does "StockQuantity" mean at all. Something beside purchased and sold?

这篇关于库存处理的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！