问题描述
首先，我是一个认真的新生儿。到目前为止，在这个数据库的设计中可能犯了无数错误。
我在华盛顿特区的一所大学担任车队技工，我正在努力追踪维修我们的车辆。为此，我创建了一个非常简单的Access 2010数据库。
一切都很顺利，直到我意识到如果没有一些帮助我就不能再进一步......所以这里我我！
为了维护我们车队车辆（即轮胎，电池，机油滤清器等）的某些部件的库存，我需要计算每件物品的数量我们应该有库存。
这是我到目前为止创建的：
To start off, I am a serious "newbe" to Access, and have probably made countless mistakes thus far in the design of this database.
I work as a fleet mechanic for a University in DC, and am trying to keep track of the maintenance on our vehicles. To do this I created a pretty simple Access 2010 database.
Everything was going pretty well until I realized that I couldn''t go any further without some help... so here I am!
In an effort to maintain an inventory of certain parts for our fleet vehicles (i.e. tires, batteries, oil filters, etc.), I need to count how many of each item we should keep in stock.
Here is what I have created thus far:
我的目标是能够打印一份报告，向我们展示每个电池的数量。那些物品（即轮胎，电池，机油滤清器等）我们应该备有库存（即我们的10辆车使用205 / 75R / 15轮胎，所以我们应该至少保留10个库存）。
任何人都可以帮我找出最好的方法吗？
提前感谢您的帮助。
dgaletar
My goal is to be able to print a report that shows us how many of each of those items (i.e. tires, batteries, oil filters, etc.) we should keep in stock (i.e. 10 of our vehicles use a 205/75R/15 tire, so we should keep at least 10 of them in stock).
Can anyone help me to figure out the best way to do this???
Thank you in advance for your assistance.
dgaletar
推荐答案
这篇关于如何为库存创建报告？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！