Space Allocatiojn [英] Space Allocatiojn

问题描述

我有一张SpaceAreas表，例如Food Store，Garden Shed等，第一个

和每个空间区域定义的最后一个bin。例如食品商店第一空间1，最后

空间26和Gargen Shed第一空间1，最后空间50.

SpaceAreas表是

SpaceAreaID Auto

SpaceAreaDesc文件

FirstSpace整数

LastSpace整数


我有一份设备的secont表存放在每个空间


空间表是

SpaceID自动

SpaceTypeID SpaceArea的长点

SpaceNo整数

EquipmentID设备的长点


打印报告的地方没有问题，但我想要一份报告全部

位置即

FoodStore 1 -

FoodStore 2黄油

....

FoodStore 26

花园棚1 -

花园棚2割草机

花园棚3 -

....

Garden Shed 50 Fork

其中有什么。很多都是空的


我试图避免用空白数据填充空间表


有任何想法请

谢谢


Phil

I have a table of SpaceAreas eg Food Store, Garden Shed etc with the first
and last bin for each Space Area defined. eg Food Store First Space 1, last
space 26 and Gargen Shed First space 1, last Space 50.
SpaceAreas Table is
SpaceAreaID Auto
SpaceAreaDesc Text
FirstSpace Integer
LastSpace Integer

I have a secont table of the Equipment Stored in each space

Space Table is
SpaceID Auto
SpaceTypeID Long Points to the SpaceArea
SpaceNo Integer
EquipmentID Long Point to the equipment

No trouble printing a report of what is where, but I want a report of All
the locations ie
FoodStore 1 -
FoodStore 2 Butter
....
FoodStore 26
Garden Shed 1 -
Garden Shed 2 Mower
Garden Shed 3 -
....
Garden Shed 50 Fork
And what is in them. Many will be empty

I am trying to avoid populating the Space Table with blank data

Any thoughts please

Thanks

Phil

推荐答案

在您的查询中，您使用的是记录源报告，双击

SpaceAreaID和SpaceTypeID之间的关系线，并将其从

a类型1更改为类型2或3.选择包含所有记录的那一个

在SpaceAreas中，只有空间中的相关记录。


PC数据表

为客户提供资源以获取Access，Excel的帮助和Word

应用程序
re******@pcdatasheet.com

" Phil Stanton" < ph ** @ stantonfamily.co.ukwrote in message

news：46 ********************** @ ptn-nntp -reader02.plus.net ...

In your query you use for the recordsource of the report, double click on
the relationship line between SpaceAreaID and SpaceTypeID and change it from
a Type 1 to a Type 2 or 3. Choose the one that says Include all the records
in SpaceAreas and only the related records in Space.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com
"Phil Stanton" <ph**@stantonfamily.co.ukwrote in message
news:46**********************@ptn-nntp-reader02.plus.net...

>我有一张SpaceAreas表，例如Food Store，Garden Shed等第一个
和最后一个bin为每个定义的空间区域。例如Food Store First Space 1，最后
空间26和Gargen Shed第一空间1，最后一个空间50.

SpaceAreas表是

SpaceAreaID Auto

SpaceAreaDesc文件

FirstSpace整数

LastSpace整数


我有一个每个空间存储的设备的secont表


空间表是

SpaceID Auto

SpaceTypeID SpaceArea的长点

SpaceNo整数

EquipmentID设备的长点


打印报告的地方没什么问题，但我要报告所有

位置即

FoodStore 1 -

FoodStore 2黄油

...

FoodStore 26

花园棚1 -

花园棚2割草机

花园棚3 -

...

花园棚50叉

什么在他们中间。很多都是空的


我试图避免用空白数据填充空间表


有任何想法请

谢谢


Phil

>I have a table of SpaceAreas eg Food Store, Garden Shed etc with the first
and last bin for each Space Area defined. eg Food Store First Space 1, last
space 26 and Gargen Shed First space 1, last Space 50.
SpaceAreas Table is
SpaceAreaID Auto
SpaceAreaDesc Text
FirstSpace Integer
LastSpace Integer

I have a secont table of the Equipment Stored in each space

Space Table is
SpaceID Auto
SpaceTypeID Long Points to the SpaceArea
SpaceNo Integer
EquipmentID Long Point to the equipment

No trouble printing a report of what is where, but I want a report of All
the locations ie
FoodStore 1 -
FoodStore 2 Butter
...
FoodStore 26
Garden Shed 1 -
Garden Shed 2 Mower
Garden Shed 3 -
...
Garden Shed 50 Fork
And what is in them. Many will be empty

I am trying to avoid populating the Space Table with blank data

Any thoughts please

Thanks

Phil

谢谢史蒂夫。


空间表中的记录实际上并不存在。我只想在报告上写一个空白的

行，以表明它们可以放入设备。


Phil

" ;史蒂夫" < so *** @ private.emailaddresswrote in message

news：HZ ***************** @ newsread1.news.pas.earthl ink。 net ...

Thanks Steve.

The records in the Space table don''t actually exist. I just want a blank
line on the report to show that they are available to put equipment in.

Phil
"Steve" <so***@private.emailaddresswrote in message
news:HZ*****************@newsread1.news.pas.earthl ink.net...

在您的查询中，您使用报告的记录源，双击

SpaceAreaID和SpaceTypeID之间的关系线并将其从类型1更改为类型2或3的
。选择在SpaceAreas中包含所有

记录的记录，并仅选择Space中的相关记录。 br />

PC数据表

为客户提供访问，Excel和Word帮助的资源

应用
re ****** @ pcdatasheet.com


" Phil Stanton" < ph ** @ stantonfamily.co.ukwrote in message

news：46 ********************** @ ptn-nntp -reader02.plus.net ...

In your query you use for the recordsource of the report, double click on
the relationship line between SpaceAreaID and SpaceTypeID and change it
from a Type 1 to a Type 2 or 3. Choose the one that says Include all the
records in SpaceAreas and only the related records in Space.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com
"Phil Stanton" <ph**@stantonfamily.co.ukwrote in message
news:46**********************@ptn-nntp-reader02.plus.net...

>>我有一张SpaceAreas表，例如Food Store，Garden Shed等第一个
和每个空间区域的最后一个bin定义。例如Food Store First Space 1，
最后一个空间26和Gargen Shed第一空间1，最后一个空间50.
SpaceAreas表是
SpaceAreaID Auto
SpaceAreaDesc文本
FirstSpace Integer
LastSpace整数

我有一个存储在每个空间的设备的secont表

空间表是
SpaceID Auto
SpaceTypeID长点到SpaceArea
SpaceNo整数
EquipmentID长点到设备

打印报告的地方没什么问题，但是我要报告所有的位置即食品店1 -
FoodStore 2黄油
......食品店26
花园棚1 -
花园棚2割草机
花园棚3 -
......
Garden Shed 50 Fork
其中有什么。很多都是空的

我试图避免用空白数据填充空间表

任何想法请

谢谢

Phil

>>I have a table of SpaceAreas eg Food Store, Garden Shed etc with the first
and last bin for each Space Area defined. eg Food Store First Space 1,
last space 26 and Gargen Shed First space 1, last Space 50.
SpaceAreas Table is
SpaceAreaID Auto
SpaceAreaDesc Text
FirstSpace Integer
LastSpace Integer

I have a secont table of the Equipment Stored in each space

Space Table is
SpaceID Auto
SpaceTypeID Long Points to the SpaceArea
SpaceNo Integer
EquipmentID Long Point to the equipment

No trouble printing a report of what is where, but I want a report of All
the locations ie
FoodStore 1 -
FoodStore 2 Butter
...
FoodStore 26
Garden Shed 1 -
Garden Shed 2 Mower
Garden Shed 3 -
...
Garden Shed 50 Fork
And what is in them. Many will be empty

I am trying to avoid populating the Space Table with blank data

Any thoughts please

Thanks

Phil

Phil，


试试建议的查询 - 你应该得到你想要的。您应该获得所有区域的

列表;在区域中有什么东西它将显示在

报告中，如果该区域为空，则该区域内的字段将为

空白。就像你的例子一样。


PC数据表

为客户提供访问，Excel和Word帮助的资源

应用程序
re******@pcdatasheet.com



Phil Stanton < ph ** @ stantonfamily.co.ukwrote in message

news：46 ********************** @ ptn-nntp -reader02.plus.net ...

Phil,

Try the suggested query - you should get what you want. You should get a
list of all areas; where there is something in the area it will show in the
report and if the area is empty, the field for what is in that area will be
blank. Just like your example.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com


"Phil Stanton" <ph**@stantonfamily.co.ukwrote in message
news:46**********************@ptn-nntp-reader02.plus.net...

谢谢史蒂夫。


空间表中的记录不要实际存在。我只想在报告中写一个空白的

行，以表明它们可以放入设备。


Phil


史蒂夫 < so *** @ private.emailaddresswrote in message

news：HZ ***************** @ newsread1.news.pas.earthl ink。 net ...

Thanks Steve.

The records in the Space table don''t actually exist. I just want a blank
line on the report to show that they are available to put equipment in.

Phil
"Steve" <so***@private.emailaddresswrote in message
news:HZ*****************@newsread1.news.pas.earthl ink.net...

>在您的查询中，您使用报告的记录源，双击SpaceAreaID和SpaceTypeID之间的关系线并更改它从类型1到类型2或3.选择一个在SpaceAreas中包含所有
记录的记录，并且只选择Space中的相关记录。

PC数据表<为客户提供访问，Excel和Word帮助的资源
应用程序
re ***** *@pcdatasheet.com

" Phil Stanton" < ph ** @ stantonfamily.co.ukwrote in message
新闻：46 ********************** @ ptn-nntp-reader02.plus .net ...

>In your query you use for the recordsource of the report, double click on
the relationship line between SpaceAreaID and SpaceTypeID and change it
from a Type 1 to a Type 2 or 3. Choose the one that says Include all the
records in SpaceAreas and only the related records in Space.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com
"Phil Stanton" <ph**@stantonfamily.co.ukwrote in message
news:46**********************@ptn-nntp-reader02.plus.net...

>>>我有一张SpaceAreas表，例如Food Store，Garden Shed等，带有
第一个和最后一个bin为每个定义的空间区域。例如食品商店第一空间
1，最后空间26和Gargen Shed第一空间1，最后空间50.
SpaceAreas表是
SpaceAreaID Auto
SpaceAreaDesc文件
FirstSpace Integer
LastSpace整数

我有一个存储在每个空间的设备的secont表

空间表是
SpaceID Auto
SpaceTypeID长点到SpaceArea
SpaceNo整数
EquipmentID长点到设备

打印报告的地方没什么问题，但我要报告
所有位置即食品店1 -
FoodStore 2黄油
......食品店26
花园棚1 -
花园棚2割草机
花园棚3 -
......
Garden Shed 50 Fork
其中有什么。很多都是空的

我试图避免用空白数据填充空间表

任何想法请

谢谢

>>>I have a table of SpaceAreas eg Food Store, Garden Shed etc with the
first and last bin for each Space Area defined. eg Food Store First Space
1, last space 26 and Gargen Shed First space 1, last Space 50.
SpaceAreas Table is
SpaceAreaID Auto
SpaceAreaDesc Text
FirstSpace Integer
LastSpace Integer

I have a secont table of the Equipment Stored in each space

Space Table is
SpaceID Auto
SpaceTypeID Long Points to the SpaceArea
SpaceNo Integer
EquipmentID Long Point to the equipment

No trouble printing a report of what is where, but I want a report of
All the locations ie
FoodStore 1 -
FoodStore 2 Butter
...
FoodStore 26
Garden Shed 1 -
Garden Shed 2 Mower
Garden Shed 3 -
...
Garden Shed 50 Fork
And what is in them. Many will be empty

I am trying to avoid populating the Space Table with blank data

Any thoughts please

Thanks

Phil

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