基本的帮助，让我开始运行我的查询 [英] basic help to start me to get my queries running

问题描述

好的，简而言之，这是我的数据库

我有一个名为''contacts''的表，其中包含有关我的会员的基本联系人和人口统计数据


我有一个名为''events''的表，列出了有关它们的事件和信息（日期，老师，地点，价格）


我有一个叫做出勤的联结表，它记录了谁来了什么。


这就是我需要的。


我希望quary能告诉我谁是最活跃的人事件是什么，它们将要发生什么，它们将要发生多少事件，想想我希望每个月左右运行一次这样的问题，并让它回答这些问题。另外Idealy我想要一个表格来说


您是否正在寻找顶级（x）人？

什么年龄范围？ （全部或具体）

什么婚姻状况？

您在什么日期范围内观看活动？




我真的不知道从哪里开始。

解决方案

有人关心帮助我吗？

< blockquote class =post_quotes>
好​​的，简而言之这里是我的数据库

我有一个名为联系人的表，其中包含关于我的成员的基本联系人和人口统计数据


我有一个名为''events''的表格，列出了有关它们的事件和信息（日期，老师，地点，价格）


我有一个连接表叫做出勤，它记录了谁来到了什么。


这是我需要的。


我希望quary告诉我谁参加活动的最活跃的人是，他们将要参加的活动，他们将要参加多少活动，想想我会想要每个月左右开一次这个问题，并让它回答这些问题秒。另外Idealy我想要一个表格来说


您是否正在寻找顶级（x）人？

什么年龄范围？ （全部或具体）

什么婚姻状况？

您在什么日期范围内观看活动？




我真的不知道从哪里开始。

首先设计查询以返回所有记录。如果你设计了这个问题，请用上面的四个问题发布，我们会告诉你如何为每个问题进行调整。


Mary

好的这里是显示所有记录的查询：

展开 | 选择 | Wrap | 行号

Ok in a a nutshell here is my database
I have a table called ''contacts'' that has basic contact and demographics about my members

I have a table called ''events'' that lists the events and info about them (date, teacher, location, price)

I have a junction table called attendance where it records who came to what.

Here is what I need.

I want the quary to tell me who the most active people that are coming to events are, what they are coming to, how many events they are coming to, Idealy I would want to run this quary once a month or so, and have it answer these questions. Also Idealy I would want a form to say

Are you looking for the top (x) people?
What age range? (all or specific)
What marital status?
What date range are you looking at activity?



I don''t really know where to start.

解决方案

Anyone care to help me?

Ok in a a nutshell here is my database
I have a table called ''contacts'' that has basic contact and demographics about my members

I have a table called ''events'' that lists the events and info about them (date, teacher, location, price)

I have a junction table called attendance where it records who came to what.

Here is what I need.

I want the quary to tell me who the most active people that are coming to events are, what they are coming to, how many events they are coming to, Idealy I would want to run this quary once a month or so, and have it answer these questions. Also Idealy I would want a form to say

Are you looking for the top (x) people?
What age range? (all or specific)
What marital status?
What date range are you looking at activity?



I don''t really know where to start.

You start by designing a query to return all records. When you have this query designed post it with the four questions above and we will tell you how it needs to be adapted for each.

Mary

OK here is the query that brings up all records:

Expand|Select|Wrap|Line Numbers

这篇关于基本的帮助，让我开始运行我的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！