Re: Reports with a grouped field.
- From: Paul <Paul@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 16 Nov 2006 05:24:02 -0800
That sort of works. It will show me ALL the cities, but I only want the
cities that match with the cities on the report. so if I select between a
date and 5 records come up, I want the five cities that match to be on the
first page.
"Allen Browne" wrote:
Open the main report in design view..
Right-click the edge of the subreport control, and choose Properties.
Clear the LinkMasterFields and LinkChildFields properties.
The subreport should then show all cities.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Paul" <Paul@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7F81AC80-F0CC-4114-8E82-1FFA77A1D7F7@xxxxxxxxxxxxxxxx
Sorry, meant to say. when linked by ID it just gave me the first city then
the main report.
"Paul" wrote:
Ok I tried that, but it only gave me the first city on the list. I linked
the
subport using the ID field. When i tried linking by city it gave me the
first
city twice. i'm a bit lost.
"Allen Browne" wrote:
Use a subreport.
1. Create a query that lists all the cities. If you don't have a
separate
table of cities, the query will be something like this:
SELECT DISTINCT City FROM Clients
WHERE City Is Not Null
ORDER BY City;
2. Create a report using that query. Save.
3. Place that report as a subreport into the Report Header section of
your
main report. If you don't see a Report Header section when you open
your
main report in design view, it's on the View menu.
"Paul" <Paul@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A59D3C78-5E43-499C-908E-5E86A1F2FFEB@xxxxxxxxxxxxxxxx
I'm trying to produce a report that was afirst page that with have a
list of the same fields then all the other pages just like a normal
report.
Like this:
front page:
CITY (list of all the city fields.)
second page
ORG NAME, ADDRESS, CITY, ect.
basicly all the city names from my report together on their own. How
is
this done?
- Follow-Ups:
- Re: Reports with a grouped field.
- From: Allen Browne
- Re: Reports with a grouped field.
- References:
- Re: Reports with a grouped field.
- From: Allen Browne
- Re: Reports with a grouped field.
- From: Allen Browne
- Re: Reports with a grouped field.
- Prev by Date: Re: Marketing handout
- Next by Date: Re: Need report to show all data
- Previous by thread: Re: Reports with a grouped field.
- Next by thread: Re: Reports with a grouped field.
- Index(es):
Relevant Pages
|
