Displaying Data

[accessuser1308]

I do not know if this is possible...but I hope someone may be able to help
me...

I have a 2 tables, one containing the core information for a group of
records and the second related to the first (but contains sub-information
related to the core). The first table (UnitInfo) contains info regarding an
overall piece of equipment, while the second table (PartsInfo) contains the
parts that are in the piece of equipment. The two tables have a relationship
using UnitID.

I have a form and subform set up for the tables and can enter all of my data
in with no problems. I would, however, like to create a report for viewing
the data. The tricky part is, I would like to have the UnitInfo at the top
of the report with the PartsInfo in a 10X10 grid layout on the report. Parts
1-10 in the first row, 11-20 in the second row, and so on. Each box in the
grid is a separate record in the PartsInfo Table. Is there code that will
allow me to do this? If it is easier to do this on a form I can use that
method as well.

Thank you for your help.

 

[George]

Do I understand correctly?The only control in your subform is a text box
which contains the Part number?

If that is correct, then you should be able to display ten parts across by
setting up the subreport with 10 columns.

The number of "rows", of course, is not so easy to accomplish as the number
of parts returned by the subform's underlying record set determines how many
columns/rows will be needed to display the entire recordset. Is it a
requirement that there be exactly 10 rows per page?

 

[Tom van Stiphout]

On Mon, 7 Apr 2008 06:44:01 -0700, accessuser1308

I don't think so, or perhaps with a really convoluted sql statement
that would give me headaches. You could look at a crosstab query, but
that's more to summarize data.
I would probably create a new table with the 10 columns (and
additional column(s) for linking data) and pre-process your normalized
data using recordsets and some VBA code.

-Tom.

 

[accessuser1308]

Hi George,

The subform has a box for part number and part name, but I only want the
number displayed on the form. I tried setting up 10 columns, but they all
display the first record in the subtable, then the second row contains the
second record in all 10 columns. Can you elaborate on how to set up the ten
columns (side by side) such that each column will have the next subsequent
record from the table?

10 rows is not a requirement. It can display only the total number of
records given for each unit. There will never be more than 100 parts, hence
the request for 10X10. It will not be a problem if it only displays 38
"grids" (10 across by 4 rows) if there are only 38 parts listed for the unit.

Again, thank you for your quick response. I am confused on how to set up 10
columns side by side such that each column will be the next record in the
table. Also, will the second row continue such that the first column will
have record 11 from the table?

Thank you for any help you can provide.

 

[accessuser1308]

Hi Tom,

Thank you for your reply,

Would you be able to give me a quick example of what you suggest?

How would I get the information from my subtable/subform PartsInfo into this
new table, formatted correctly, such that all of the information is still in
the correct order?

Thank you

 

[George]

What I was thinking was that you'd use Page Setup to change the subform to a
10 column format, but that the detail section of the subform would only have
that one text box on it. That didn't work?

George

 

[accessuser1308]

I understand now. This worked perfectly. Thank you.

 

[George Hepworth]

Cool. Glad you found your solution.

I understand now. This worked perfectly. Thank you.

 

[Mathou]

kiss tous