Duplicated field in columns

J

jyoung729

Page Header:
Specie Field Door Height Field
-------------------------------------------------------
Door Header:
Door Image Field
Door # Field
Door Name Field
---------------------------------------------------------
Description Header:
Description Field
Code Field
(These are on top of each other like size & price fields with the same code)
----------------------------------------------------
Detail:
Size Field
Price Field
(These are on top of each other)
---------------------------------------------------
Page Footer:
Date Page #
-------------------------------------------------------

Here is a copy and paste of the query info. This is all the pricing info
about the first door. It doesn't really fit in here as there's just too much
info. Do you have an email were I could send you a pdf so you can see it more
accurately?

Image Door Door # Type Order Specie
Description Code Door Order Size Height Price
2 Panel Square Top 82B 1 Fir - Double Hip Raised
Panel "1-3/8""" IHF82DH 1 1/6 x 6/8 6/8 $227.000
2 Panel Square Top 82B 1 Fir - Double Hip Raised
Panel "1-3/8""" IHF82DH 1 1/8 x 6/8 6/8 $227.000
2 Panel Square Top 82B 1 Fir - Double Hip Raised
Panel "1-3/8""" IHF82DH 1 2/0 x 6/8 6/8 $238.000
2 Panel Square Top 82B 1 Fir - Double Hip Raised
Panel "1-3/8""" IHF82DH 1 2/2 x 6/8 6/8 $238.000
2 Panel Square Top 82B 1 Fir - Double Hip Raised
Panel "1-3/8""" IHF82DH 1 2/4 x 6/8 6/8 $238.000
2 Panel Square Top 82B 1 Fir - Double Hip Raised
Panel "1-3/8""" IHF82DH 1 2/6 x 6/8 6/8 $245.000
2 Panel Square Top 82B 1 Fir - Double Hip Raised
Panel "1-3/8""" IHF82DH 1 2/8 x 6/8 6/8 $251.000
2 Panel Square Top 82B 1 Fir - Double Hip Raised
Panel "1-3/8""" IHF82DH 1 2/10 x 6/8 6/8 $262.000
2 Panel Square Top 82B 1 Fir - Double Hip Raised
Panel "1-3/8""" IHF82DH 1 3/0 x 6/8 6/8 $262.000
2 Panel Square Top 82B 2 Fir - Double Hip Raised Panel "1-3/8""
Bifold" IBHF44DH 1 2/0 x 6/8 - 2 Doors 6/8 $240.000
2 Panel Square Top 82B 2 Fir - Double Hip Raised Panel "1-3/8""
Bifold" IBHF44DH 1 2/6 x 6/8 - 2 Doors 6/8 $255.000
2 Panel Square Top 82B 2 Fir - Double Hip Raised Panel "1-3/8""
Bifold" IBHF44DH 1 2/8 x 6/8 - 2 Doors 6/8 $270.000
2 Panel Square Top 82B 2 Fir - Double Hip Raised Panel "1-3/8""
Bifold" IBHF44DH 1 3/0 x 6/8 - 2 Doors 6/8 $285.000
2 Panel Square Top 82B 2 Fir - Double Hip Raised Panel "1-3/8""
Bifold" IBHF44DH 1 4/0 x 6/8 - 4 Doors 6/8 $480.000
2 Panel Square Top 82B 2 Fir - Double Hip Raised Panel "1-3/8""
Bifold" IBHF44DH 1 5/0 x 6/8 - 4 Doors 6/8 $510.000
2 Panel Square Top 82B 2 Fir - Double Hip Raised Panel "1-3/8""
Bifold" IBHF44DH 1 5/4 x 6/8 - 4 Doors 6/8 $540.000
2 Panel Square Top 82B 2 Fir - Double Hip Raised Panel "1-3/8""
Bifold" IBHF44DH 1 6/0 x 6/8 - 4 Doors 6/8 $570.000
 
M

Marshall Barton

jyoung729 said:
Page Header:
Specie Field Door Height Field
-------------------------------------------------------
Door Header:
Door Image Field
Door # Field
Door Name Field
---------------------------------------------------------
Description Header:
Description Field
Code Field
(These are on top of each other like size & price fields with the same code)
----------------------------------------------------
Detail:
Size Field
Price Field
(These are on top of each other)
---------------------------------------------------
Page Footer:
Date Page #
-------------------------------------------------------

Here is a copy and paste of the query info. This is all the pricing info
about the first door. It doesn't really fit in here as there's just too much
info. Do you have an email were I could send you a pdf so you can see it more
accurately?

Image Door Door # Type Order Specie
Description Code Door Order Size Height Price
2 Panel Square Top 82B 1 Fir - Double Hip Raised
Panel "1-3/8""" IHF82DH 1 1/6 x 6/8 6/8 $227.000
2 Panel Square Top 82B 1 Fir - Double Hip Raised
Panel "1-3/8""" IHF82DH 1 1/8 x 6/8 6/8 $227.000
2 Panel Square Top 82B 1 Fir - Double Hip Raised
Panel "1-3/8""" IHF82DH 1 2/0 x 6/8 6/8 $238.000
2 Panel Square Top 82B 1 Fir - Double Hip Raised
Panel "1-3/8""" IHF82DH 1 2/2 x 6/8 6/8 $238.000
2 Panel Square Top 82B 1 Fir - Double Hip Raised
Panel "1-3/8""" IHF82DH 1 2/4 x 6/8 6/8 $238.000
2 Panel Square Top 82B 1 Fir - Double Hip Raised
Panel "1-3/8""" IHF82DH 1 2/6 x 6/8 6/8 $245.000
2 Panel Square Top 82B 1 Fir - Double Hip Raised
Panel "1-3/8""" IHF82DH 1 2/8 x 6/8 6/8 $251.000
2 Panel Square Top 82B 1 Fir - Double Hip Raised
Panel "1-3/8""" IHF82DH 1 2/10 x 6/8 6/8 $262.000
2 Panel Square Top 82B 1 Fir - Double Hip Raised
Panel "1-3/8""" IHF82DH 1 3/0 x 6/8 6/8 $262.000
2 Panel Square Top 82B 2 Fir - Double Hip Raised Panel "1-3/8""
Bifold" IBHF44DH 1 2/0 x 6/8 - 2 Doors 6/8 $240.000
2 Panel Square Top 82B 2 Fir - Double Hip Raised Panel "1-3/8""
Bifold" IBHF44DH 1 2/6 x 6/8 - 2 Doors 6/8 $255.000
2 Panel Square Top 82B 2 Fir - Double Hip Raised Panel "1-3/8""
Bifold" IBHF44DH 1 2/8 x 6/8 - 2 Doors 6/8 $270.000
2 Panel Square Top 82B 2 Fir - Double Hip Raised Panel "1-3/8""
Bifold" IBHF44DH 1 3/0 x 6/8 - 2 Doors 6/8 $285.000
2 Panel Square Top 82B 2 Fir - Double Hip Raised Panel "1-3/8""
Bifold" IBHF44DH 1 4/0 x 6/8 - 4 Doors 6/8 $480.000
2 Panel Square Top 82B 2 Fir - Double Hip Raised Panel "1-3/8""
Bifold" IBHF44DH 1 5/0 x 6/8 - 4 Doors 6/8 $510.000
2 Panel Square Top 82B 2 Fir - Double Hip Raised Panel "1-3/8""
Bifold" IBHF44DH 1 5/4 x 6/8 - 4 Doors 6/8 $540.000
2 Panel Square Top 82B 2 Fir - Double Hip Raised Panel "1-3/8""
Bifold" IBHF44DH 1 6/0 x 6/8 - 4 Doors 6/8 $570.000
Click to expand...


Well, now I am totally befuddled. The sample data has a
different size for every record in each door#/description
group so I can't see how the report's design relates to the
data.

You said something about the description header being "like
size & price fields with the same code"?? The code we're
using for the detail can not be used in a group header
section no way, no how. So, that probably has something to
do with the confusing output you are seeing. It sure seems
to me that the description include the number of panels so
how can you group on the door# or description?

To do what you want the doors of each type(?) and size must
be grouped together, but I don't see a field that can be
used to sort the 2 panel, 3 panel, etc in that order for
each size. If there is, please sort the query the same way
you want the report sorted and post that sample.
 
J

jyoung729

My overall goals for this project that I am working on is getting our price
books into a database format so we can be more streamlined and accurate. In
terms of the report design, I am trying to make it look like our previous
price pages that were all input by hand, as this is what has been requested
of me. In doing that, I realize this may not be the most efficient or logical
way for a report to be set up, but drastically changing the look of our price
pages was not an option.

Each door has a total of 17 different sizes with a corresponding price for
each size. Within those sizes, there are two different descriptions. One is
1-3/8" and the other is 1-3/8" Bifold. The doors in 1-3/8" have a product
code that is different from the 1-3/8" Bifold doors. I need to have the
description listed once above their corresponding sizes and then the code
listed once above it's corresponding price column. At the top of the page,
above each price column, I need to list the door# and the door name.

In regards to not being able to use that code in the group header, I'm a bit
confused. I have it in there and it's working the way it's suppose to. It
displays the Description above the size column and then the codes of the
price columns.

As for the order, I have a Door Order field and a Type Order field. The door
order being the order I want the doors to appear, ie 2 panel, then 3 panel,
etc. The type order field is for the order of the description types on the
page, ie 1-3/8", then 1-3/8" Bifold. I then have the order of how the sizes
and prices appear based on the ID field. Everything is in numerical order by
size in my tables, therefore making it easy to just sort by the ID field that
is also in numerical order.

I hope I understood your questions correctly and this helps clear up some
confusion.
 
M

Marshall Barton

jyoung729 said:
My overall goals for this project that I am working on is getting our price
books into a database format so we can be more streamlined and accurate. In
terms of the report design, I am trying to make it look like our previous
price pages that were all input by hand, as this is what has been requested
of me. In doing that, I realize this may not be the most efficient or logical
way for a report to be set up, but drastically changing the look of our price
pages was not an option.

Each door has a total of 17 different sizes with a corresponding price for
each size. Within those sizes, there are two different descriptions. One is
1-3/8" and the other is 1-3/8" Bifold. The doors in 1-3/8" have a product
code that is different from the 1-3/8" Bifold doors. I need to have the
description listed once above their corresponding sizes and then the code
listed once above it's corresponding price column. At the top of the page,
above each price column, I need to list the door# and the door name.

In regards to not being able to use that code in the group header, I'm a bit
confused. I have it in there and it's working the way it's suppose to. It
displays the Description above the size column and then the codes of the
price columns.

As for the order, I have a Door Order field and a Type Order field. The door
order being the order I want the doors to appear, ie 2 panel, then 3 panel,
etc. The type order field is for the order of the description types on the
page, ie 1-3/8", then 1-3/8" Bifold. I then have the order of how the sizes
and prices appear based on the ID field. Everything is in numerical order by
size in my tables, therefore making it easy to just sort by the ID field that
is also in numerical order.

I hope I understood your questions correctly and this helps clear up some
confusion.
Click to expand...


I have been tied up over a long weekend, but I am still
trying to come up with a way to deal with this arrangement.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeating Information 9
Dates In Excel 5
Mail Merge Help 1
Setting column width in a table with a macro is not working 0
Use a variable in a ShapeRange.Increment 0
Consolidation Table from Different Excel Tabs with Different Format 1
How can the font and size of (all) citation numbers be altered? 1
Microsoft 365 Activations, Users or Devices? 0

Top