你能否以连续的形式分组记录？ [英] Can you group records within a continuous form?

问题描述

大家好，可能是一个基本的问题，但已经挣扎了一段时间，所以以为我会看看你是否可以提供帮助。


我有一个主要的时间表，其中包含字段......

日期;机;臂/头;工作编号;股票代码;操作; QtyPred; QtyAct


我的理想形式是连续的（所以我可以轻松搜索选择的日期，例如.01 / 12/2008 - 09/12/2007）但需要有每个日期只有一条记录。 ***我的问题是该表包含每个日期的许多记录。有没有办法对表格的结果进行分组，然后根据这些结果生成连续的表格。


NB我明白我可以创建一个搜索机器的qry;手臂/头部限制结果但我希望有一个包含最多6个工作号的日期的记录及其相关的6个股票代码，6个操作员，6个QTYPred和6个QTYAct。


我希望你能帮助我


非常感谢提前，OllyJ

Hi guys, probably a basic question but have been struggling for some time so thought i''d see if you could help.

I have a main schedule table which contains the fields...
Date; Machine; Arm/Head; Job Number; Stock Code; Operator; QtyPred; QtyAct

My ideal form would be a continuous one (so I can easily search through a selection of dates eg. 01/12/2008 - 09/12/2007) but need to have only one record per date. *** My problem is that the table contains many records per date. Is there any way of grouping the results of a table and then producing a continuous form based on these results.

NB I understand that I can create a qry to search machine; arm/head to LIMIT the results but then I wish to have a single record for a date containing up to 6 Job Numbers with their relevant 6 Stock Codes, 6 Operators, 6 QTYPred and 6 QTYAct.

I hope you can help me

Many thanks in advance, OllyJ

推荐答案

我不会低估它正确但仍然，尝试我们子表单

I havn''t understud it properly but still , try to us subform

感谢您的回复，但你不能使用连续形式的子表单，好吧...至少我不知道一个圆的方式那个！

Thank you for your response but you cannot use subforms within a continuous form, well... at least I don''t know a way round that!

如果您只是在寻找排序，可以使用查询作为表单的数据源来完成。如果您想编辑这些记录，则不能使用聚合查询（groupby，sum，count等）。


如果您希望以连续形式一起显示一组记录制作子表单并制作驱动该组的父表单。


发布有关数据集的更多详细信息，供所有人查看和/或更详细地说明您的内容试图这样做。

If you are just looking for sorts, this can be done with a query as a datasource for the form. If you wish to edit these records you cannot use an aggregate query (groupby, sum, count, etc).

If you are looking to show a group of records together in a continuous form the make that the subform and make a parent form that drives the group.

Post more details of the dataset in question for all to see and/or a more detailed description of what you are trying to do.

这篇关于你能否以连续的形式分组记录？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！