Re: Remove repeat section headers

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I think I need an extra field that can be grouped on and contains (123or4)
(but I have another question on how to do this in the query by testing each
type for null). I wish I had ignored my attempts to keep the number of
tables down and stored these records in 4 seperate tables! There's enough of
them and most of each record is blank...(the example is a trifle of all
fields!) I thought that I had the design right this time too much time spent
listening to too much advice, now its a pain and I cannot go back. (Two
weeks over deadline).

Any thoughts?


"Starry" <nospam> wrote in message
news:%23UGeE81VHHA.3592@xxxxxxxxxxxxxxxxxxxxxxx
Hi Duane

The fields all have equal importance there is a higher key field (JNum)
but as the report only relates to a single JNum it makes no odds. Looking
again the groups cannot help but keep restarting. I have realised that I
don't actually want it to group within the types but rather group the
entire type1 2 3 or 4...ie just to show a new header when a type has (or
has not) data.

If I remove the groups i get (which is the table layout)
header
TYPE1 TYPE2 TYPE3
type1
type1
type1
type2
type2
type3
type3
etc.

but I need to have a header (and footer) for each and mess with the
positions so that we get

Header
type1
type1
type1
Header
type2
type2
Header
type3
type3

I could just shove all the fields ontop of each other in the detail
section (uggh!) but that still leaves the header/footer problem.
No matter what settings I use for group it will not leave them in a chunk.
I need the group header/footer but not the grouping!




"Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxxx> wrote in message
news:FA016806-51BF-4542-8696-4EE1D40C7B02@xxxxxxxxxxxxxxxx
Could you provide the fields/expressions from your sorting and group
dialog?
You might only need to change their order.
--
Duane Hookom
Microsoft Access MVP


"Starry" wrote:

My report groups data correctly but adds a new section header for each
different entry in the grouping field. I want it to display this header
once
and run all records in that group as detail. This should make it clear!

tbldata
record: type1(blank) type2(blank) type3(blank) type4(stuff)
record: type1(blank) type2(blank) type3(blank) type4(stuff)
record: type1(blank) type2(blank) type3(blank) type4(morestuff)
record: type1(otherstuff) type2(blank) type3(blank) type4(blank)
record: type1(moreotherstuff) type2(blank) type3(blank) type4(blank)

report looks like this.....

type4 section header
type4(stuff)
type4(stuff)

type4 section header
type4(morestuff)

type1 section header
type1(otherstuff)

type1 section header
type1(moreotherstuff)

so within the grouping every time the data changes in my groupby field I
get
a new header. Just the one PLEASE! Can I code this out? or do I have to
add
a field to my table to specify what type a particular record is...surely
not?

Any help much appreciated







.

Relevant Pages

  • Re: Remove repeat section headers
    ... actually want it to group within the types but rather group the entire type1 ... but I need to have a header for each and mess with the ...
    (microsoft.public.access.reports)
  • Re: Remove repeat section headers
    ... I'll stick with my assessment that a union query might resolve your issue. ... 'Type' field names and data types, and desired display in your report. ... but I need to have a header for each and mess with the ...
    (microsoft.public.access.reports)
  • Re: Remove repeat section headers
    ... The query output is fine as is I just cannot make the report lay the results ... but I need to have a header for each and mess with the ...
    (microsoft.public.access.reports)
  • Re: Remove repeat section headers
    ... WHERE MatSupp Is Not Null ... Use this union query and group by ItemTYpe or whatever... ... JobNum (page header) single job only ...
    (microsoft.public.access.reports)
  • Re: Remove repeat section headers
    ... Matsupp - Text* ... JobNum (page header) single job only ... 'Type' field names and data types, and desired display in your report. ...
    (microsoft.public.access.reports)