麻烦计数/分离记录 [英] Trouble Counting/Separating Records
问题描述
我是新手（我正在使用Access 2010版本）而且我变得疯狂了。还要考虑到我一般都是DB的新手，所以现在我很困惑......请帮助。
我有一个跟踪的数据库我们所有的工作卡车。到目前为止，它完美地运作。现在我的老板希望我们跟踪我们使用的每种尺寸挡风玻璃刮水器的数量。现在我知道这听起来并不难，但它已经让我疯了一个多星期了!!!
问题是每辆卡车都可以起来至上面有3个挡风玻璃刮水器......（1）DS（驾驶员侧），（1）PS（乘客侧），和（1）后部。
我需要捕获的信息只是每个尺寸刮水器的总数量。例如，卡车＃1使用18英寸的卡车。 DS上的雨刷，16英寸PS上的雨刮器，后部没有雨刮器。卡车＃2使用18英寸的卡车。 DS上的雨刷，18英寸PS上的雨刷，以及12英寸的雨刮器在后部。这意味着我们使用（1）16刮水器，（3）18刮水器，和（1）12刮水器。
看起来很简单，但对于我的生活，我无法弄清楚如何做到这一点!!!
我已附上数据库的拉链供您查看。
**在导航页面的一般详细信息：下，选择 - 查看和/或全部编辑车辆记录链接。在右下角，在SERVICE SPECS中。子表单是wipers输入字段所在的位置。下拉列表从刮水器获取信息。表格和刮水器信息收集在SERVICE_SPECS中。表。
祝你好运，谢谢！
dgaletar
I am new to access (I am using Access 2010 version) and I am getting crazy. Consider also that I am a novice with DB in general, so now I am at the point that I am very confused... please help.
I have a database that keeps track of all of our work trucks. So far it has worked perfectly. Now my boss wants us to track how many of each size of windshield wipers we use. Now I know that this doesn''t sound difficult, but it has driven me nuts for over a week now!!!
The problem is that each truck can have up to 3 windshield wipers on it... (1) DS (Drivers side), (1) PS (Passenger side), and (1) Rear.
The only information that I need to capture is the total quantity of each size wiper. Example, truck #1 uses a 18" wiper on the DS, a 16" wiper on the PS, and none on the rear. While truck #2 uses a 18" wiper on the DS, a 18" wiper on the PS, and a 12" wiper on the rear. That means that we use (1) 16" wiper, (3) 18" wipers, and (1) 12" wiper.
Seems simple, but for the life of me I can''t figure out how to do this!!!
I have attached a zip of the database for your review.
**On the Navigation Page, under "General Details:", select the "- View and/or Edit All Vehicle Records" link. In the bottom right hand corner, in the "SERVICE SPECS" subform is where the wipers input fields are located. The dropdowns get their information from the "Wipers" table, and the wipers information is collected in the "SERVICE_SPECS" table.
Good luck and THANK YOU!!!
dgaletar
推荐答案
BTW，我刚发现此代码在另一个论坛中。有没有人认为我是在正确的轨道上尝试使用这个???
BTW, I just found this code in another forum. Does anybody think that I am on the right track by trying to use this???
我不相信Allen Browne的代码是你正在寻找的。尝试查看交叉表查询。我相信这更符合您的要求。 Crosstab查询应该可以帮助您。如果您遇到问题，请告诉我们。
I don''t believe that Allen Browne''s code is what you are looking for. Try looking into crosstab queries. I believe that is more along the line of what you are looking for. Crosstab Queries should help you along. Let us know if you have trouble with it.
Dgaletar：
欢迎回来。
我会选择Seth on this并提供了一个数据透视表的选项。
>
只是提醒一下，我们大多数人都不会打开未经请求的附件一般的预备。它不应该被视为个人攻击 - 只是人们经常会在没有任何知识的情况下被感染。
你还应该记住你过去的经历，只是说明你的代码没有不工作，发布代码或数据库而不解释已执行的故障排除（如果有），并期望有人提供帮助通常不会导致大量答案，可能导致您的线程被删除。
相反，请告诉我们您对每个错误的期望，实际发生的事情：完整的标题，错误编号，以及发生的描述以及在哪一行您发布的代码错误发生了。这些是发布此类问题的最低要求。
Dgaletar:
Welcome back.
I would go with Seth on this and offer the option of a pivot table as well.
>
Just a reminder, most of us will not open an unsolicited attachment as a general precation. It should not be taken as a personal attack - just that people will often be infected without any knowledge.
You should also remember from your past experience, simply stating that your code "doesn''t work," posting code or a database without explaining what, if any, troubleshooting has been performed, and expecting someone to help doesn''t usually result in much of an answer and may result in your thread being deleted.
Instead, please tell us what you were expecting to happen, what actually happened, for each error: the EXACT title, error number, and descriptions that occurred and at what line in your posted code the error occurred. These are the minimum requirements for posting a question of this nature.
这篇关于麻烦计数/分离记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
