By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,804 Members | 1,634 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,804 IT Pros & Developers. It's quick & easy.

sub query on reports??

P: n/a
I two tables one of real estate properties and the other is a table of
tenants. The Tenants table has a PropertyIndex field which ties the tenants
to the propertys.

I have a query that lists the properties and its tenants but it cannot be
used for a report because it doesn't know what to do with the additional
fields when there are more than one tenant.

I would like to to list

Property Name
Address
City, State zip

Tenant 1 Name
Tenant 2 Name
....

Should I use a subreport here or well I'm not sure.

Thanks for your help!!

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Looks to me like the kind of thing that Subreports were intended for. Create
a separate Report for Tenant information and embed it in the Subreport
Control, specifying the unique id for Property and the foreign key from
Tenant to Propert as the LinkMasterFields and LinkChildFields of the
Subreport Control.

If all the information for property and the first tenant would fit on one
line, you could just use "hide duplicates" on the property information, and
would not need a subreport.

Larry Linson
Microsoft Access MVP

"John" <Jo**@john.net> wrote in message
news:jfa%b.58986$4o.76809@attbi_s52...
I two tables one of real estate properties and the other is a table of
tenants. The Tenants table has a PropertyIndex field which ties the tenants to the propertys.

I have a query that lists the properties and its tenants but it cannot be
used for a report because it doesn't know what to do with the additional
fields when there are more than one tenant.

I would like to to list

Property Name
Address
City, State zip

Tenant 1 Name
Tenant 2 Name
...

Should I use a subreport here or well I'm not sure.

Thanks for your help!!

Nov 12 '05 #2

P: n/a
WOW Thanks for your help !!!!

I had tried the subreports wizard earlier but couldn't get it working, in
the help files is says makes sure the wizard button is pressed then press
subreports. I was trying to get the wizard button pressed in the main tool
bar and it would pop back up and not stay selected.

Anyway, it works well now thanks. Is there a way to make my report so only
one property is printed. When linking it say

'show Tenants for each record in PropertysMain using PropertyIndex'

Although PropertysMain is based on a parameter based query (and therefore
asks for the parameter) it ends up showing all the Propertys creating a huge
report when I only wanted to show one at a time.

Thanks again for your help, I'm happy to get this far.

Regards

"Larry Linson" <bo*****@localhost.not> wrote in message
news:Ya***************@nwrddc03.gnilink.net...
Looks to me like the kind of thing that Subreports were intended for. Create a separate Report for Tenant information and embed it in the Subreport
Control, specifying the unique id for Property and the foreign key from
Tenant to Propert as the LinkMasterFields and LinkChildFields of the
Subreport Control.

If all the information for property and the first tenant would fit on one
line, you could just use "hide duplicates" on the property information, and would not need a subreport.

Larry Linson
Microsoft Access MVP

"John" <Jo**@john.net> wrote in message
news:jfa%b.58986$4o.76809@attbi_s52...
I two tables one of real estate properties and the other is a table of
tenants. The Tenants table has a PropertyIndex field which ties the

tenants
to the propertys.

I have a query that lists the properties and its tenants but it cannot be used for a report because it doesn't know what to do with the additional
fields when there are more than one tenant.

I would like to to list

Property Name
Address
City, State zip

Tenant 1 Name
Tenant 2 Name
...

Should I use a subreport here or well I'm not sure.

Thanks for your help!!


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.