数据库在没有库存时显示产品 [英] Database displays products when none in stock

问题描述

我创建了一个显示产品摘要的报告。

问题是即使没有库存也会显示所有产品。

是另一种方法是让报告只显示库存产品，即。大于零？

I have created a report that displays a "Product Summery".
The problem is that it displays all products even when there is none in stock.
Is ther a way to get the report to display only the products in stock ie. greater than zero?

推荐答案

简单的解决方案是将报表基于库存水平标准> 0的查询。这应该是非常简单的，但是如果你遇到困难，请发布你的数据库结构，我/某人就能提供答案！

Simple solution would be to base the report off of a query where the criteria for stock level is >0. This should be quite straightforward but if you get stuck, post up your database structure and I/someone will be able to provide an answer!

当我说创建一个报告我应该说 ;有一份报告当我下载它时，数据库附带了它。

希望我附上了数据库的压缩副本，这样你就可以看到它。

我不愿意把它搞得一团糟格式cos对我有用，我可以看到，稍后当数据库上有更多内容时，报告将是无穷无尽的，所以它只是删除所有那些零持有的东西？ Iff它可能。

Ezzz

When i say created a report i should have said "have a report" that came with the database when i down loaded it.
Hopefully i have attached a zipped copy of the database so you can see it.
I am reluctant to mess with the format cos it works for me, I can just see that later on when there is more on the database the report will be endless so it just made sence to remove all those with zero holdings? Iff its possible.
Ezzz

附加文件

工作库存管理数据库副本.zip （2.73 MB，57 views）

Attached Files

Copy of Working Inventory management database.zip (2.73 MB, 57 views)

我恐怕无法打开你的附件，因为我正在使用Access 2000.如果你可以转换它，然后我会看看。

I''m afraid I can''t open your attachment because I am using Access 2000. If you can convert it, then I''ll take a look.

这篇关于数据库在没有库存时显示产品的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！