访问查询中的多个记录 [英] Multiple records in Access Queries

问题描述

我已经建立了一个包含客户记录的数据库，以及我们与他们进行过互动的单独表格。 我想创建一个报告，整合每个客户名称下的所有互动。 我已经能够做到
了，但是有一个小故障。

I have built a database that contains records for clients and a separate table for interactions that we've had with them.  I would like to create a report that consolidates all of the interactions under each client's name.  I've been able to do this, but have a glitch.

如果我遇到过三次客户端，我的查询会显示每次交互的三行。 它在报告中出现三次。 所有信息都包含在每个实例中。

If I have met with a client three times, My query shows three rows for each interaction.  It appears in a report as three times.  All of the info is included in each instance.

Acme Plumbing

     互动1

     互动2

     互动3

Acme Plumbing
     Interaction 1
     Interaction 2
     Interaction 3

Acme Plumbing

     互动1

     互动2

     互动3

Acme Plumbing
     Interaction 1
     Interaction 2
     Interaction 3

Acme Plumbing

     互动1

     互动2

     互动3

Acme Plumbing
     Interaction 1
     Interaction 2
     Interaction 3

如何修改我的查询或报告，以便供应商只出现一次，下面列出了所有三种互动？

How can I amend my query or report so that the vendor only appears once, with all three interactions listed below it?

推荐答案

1. 创建报告对存储客户名称的字段名称进行分组
2. 将报告字段名称移动到该组标题中
3. 将客户端字段名称"隐藏重复项"属性设置为是

这篇关于访问查询中的多个记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！