如何为库存创建报告？ [英] How do I create a report for our inventory?

问题描述

首先，我是一个认真的新生儿。到目前为止，在这个数据库的设计中可能犯了无数错误。


我在华盛顿特区的一所大学担任车队技工，我正在努力追踪维修我们的车辆。为此，我创建了一个非常简单的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:

1。由每个车辆基本信息（即卡车号，车牌号，VIN号等）组成的主表格/表格。此表格/表格的主键是我们分配给它的卡车号码。


2.主表单上的子表格/表格，用于托管特定的动力传动系统 ;每种车辆的信息（即发动机尺寸，传动类型，座位容量等）。


3.主表格上的另一个子表格/表格，用于托管每辆车辆使用的零件。

• 第二个子表从托管自己使用的产品的单独表中提取所有数据选择（即轮胎：table =包含这些车辆使用的所有轮胎尺寸的清单;电池：table =包含这些车辆使用的所有电池的清单;等等。）

1. A main form/table consisting of each vehicles basic info (i.e. truck number, license plate numbers, VIN numbers, etc.). The primary key for this form/table is the truck number that we have assigned to it.

2. A sub-table/form on the main form that hosts the specific "drivetrain" information for each of these vehicles (i.e. engine size, transmission type, seating capacities, etc.).

3. Another sub-table/form on the main form that hosts each vehicles specific parts used.

• The second sub-table pulls all of its data choices from separate tables that host the products used themselves (i.e. tires: table = holds a listing of all of the tire sizes that these vehicles use; batteries: table = holds a listing of all of the batteries that these vehicles use; etc.).

我的目标是能够打印一份报告，向我们展示每个电池的数量。那些物品（即轮胎，电池，机油滤清器等）我们应该备有库存（即我们的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

推荐答案

可以你发布表格布局和一些样本数据？单独从描述中看到表格/数据关系很困难。

Can you post the table layouts and some sample data? It''s difficult to see the table/data relationships from the description alone.

在不同的帖子中发布各种图片 - 其中任何一个都不可见，无法使用。

Various images posted in separate posts - none of which were visible enough to be any use.

那些截图太小，看不到，你可以输入吗？

Those screenshots are too small to see, can you type it out instead?

这篇关于如何为库存创建报告？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！