访问查询 [英] Access Query

问题描述

我正在开发月度Fasion杂志的新数据库（3种类型 - 涵盖性别和所有年龄段），免费分发到商场，酒店，办公室等，杂志是分发复制3个不同的时间与月份（bcz整个月流通，一直可供人们使用）。我们有很多场地（分布的地方=商场，酒店，办公室等）。


现在我们正在为excel表维护每个发行版的数据。每个月有3个工作表（bcz每月3次分发），每个月我们都在创建新文件。我按照时间分布和月份将所有表格转移到表格。


现在我的问题是我想创建一个查询，总计我们在一个月内向个别地点分配的数量还有几个月的杂志类型和场地。


Imthiyaz

Hi,
I m developing the new database for Monthly Fasion Magazines(3types-To Cover both genders and all the ages) distrubuting freely to the malls, Hotels, Offices etc., The magazines are distributed copies 3 different time with in the month(bcz to circulate whole month and available to people all the time). We have lots of venue(The places for Distribution=Malls, Hotels, Office, etc.,).

Now currently we are maintaining the data by excel sheet for every distribution. Every month has 3 worksheet(bcz 3 times distribution per month) and every month we are creating new file. And i transfered all the sheet to the tables by the times distribution and months.

Now My question is I want to create a query to total how much we distributed to individual venue in one month and also for few months by type of magazines and by the venue.

Imthiyaz

推荐答案

...现在我的问题是我想创建一个查询，总计我们在一个月内分配给个别场地的数量，以及按杂志类型和场地分发的几个月。

Imthiyaz

...Now My question is I want to create a query to total how much we distributed to individual venue in one month and also for few months by type of magazines and by the venue.
Imthiyaz

听起来好像实际的查询会相对简单。但你能否详细说明你的表格是如何布局的？

It sounds as though the actual queries will be relatively simple. But could you post details of how your table(s) is/are laid out?

听起来好像实际的查询将是相对简单。但是你能否详细说明你的桌子是如何布置的？

It sounds as though the actual queries will be relatively simple. But could you post details of how your table(s) is/are laid out?

我的数据库中有九个表。每个月有3个桌子（Bcz 3次分发到同一场地（即场地/客户）。现在我有3个月的数据。每隔3个月我们需要提交Bcz进行审核。

桌子像Venue Id，Venue Name，Address，1ds，1gw，1ml（1ds，1gw，1ml是3种类型的杂志），Total（all3）和另一个表包含相同的字段，除了2ds，2gw，2ml（这意味着2和杂志的分发一样。对于第三次分发来说是明智的。


现在我想总计我们在一个月内分配到3个月的单一场地.Bcz正如我之前所说，我们需要审计。


我希望你理解并期待你的回答。


Imthiyaz

I have nine tables in my Database. Everymonth has 3 tables(Bcz 3 time Distribution to the same venue(i.e- Venue/Customer). Now i have data for 3 Months. Bcz every 3 month we need to submit for audit.
The Table as the fields like Venue Id, Venue Name, Address, 1ds,1gw,1ml(1ds,1gw,1ml are 3 types of magazines), Total(all3) and another table contains same fields except 2ds,2gw,2ml(It means 2 nd distribution of the magazine). Like wise for 3 rd distribution.

Now i want to total how much we distributed in the month as well as for 3 month to the single Venue. Bcz we need for auditing as i said before.

I hope u understand and expecting ur answer.

Imthiyaz

我的数据库中有九个表。每个月有3个表（Bcz 3次分配到同一地点（即场地/客户）。现在我有数据3个月.Bcz每3个月我们需要提交审核。

表格为字段li ke Venue Id，Venue Name，Address，1ds，1gw，1ml（1ds，1gw，1ml是3种类型的杂志），Total（all3）和另一个表包含相同的字段，除了2ds，2gw，2ml（这意味着第2次分发该杂志）。像第三次分发一样明智。


现在我想总计我们在本月以及3个月内向单一地点分配的金额。正如我之前所说，我们需要审计。


我希望你明白并期待你的回答。


Imthiyaz

I have nine tables in my Database. Everymonth has 3 tables(Bcz 3 time Distribution to the same venue(i.e- Venue/Customer). Now i have data for 3 Months. Bcz every 3 month we need to submit for audit.
The Table as the fields like Venue Id, Venue Name, Address, 1ds,1gw,1ml(1ds,1gw,1ml are 3 types of magazines), Total(all3) and another table contains same fields except 2ds,2gw,2ml(It means 2 nd distribution of the magazine). Like wise for 3 rd distribution.

Now i want to total how much we distributed in the month as well as for 3 month to the single Venue. Bcz we need for auditing as i said before.

I hope u understand and expecting ur answer.

Imthiyaz

有人在那帮助我。你好Mr.Killer你明白我对DB的解释。如果您需要更多信息，我将提供您。

Anybody there to help me. Hello Mr.Killer did u understand my explanation about DB. If u want more info i will provide u.

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