Data Fur Report

[Steve]

The following data needs to be placed in a preprinted report:
AssemblyID Assembly ComponentID Component
1 A 1
X1
1 A 2
X2
2 B 3
Y1
2 B 4
Y2
2 B 5
Y3
2 B 6
Y4
2 B 7
Y5
3 C 1
X1
3 C 2
X2
3 C 4
Y3
3 C 5
Y4
3 C 8
Z1
3 C 9
Z2
3 C 10 Z3

The components for a specific assembly need to be concatenated in the
preprinted report. There is only room for three components in a line. When
there are more than three components(Assembly B), the next three components
need to be placed in a second line. .And when there are more than six
components (Assembly C), The next three components need to be placed in a
third line. I need a query that returns the following results for the above
data:

A X1, X2
B Y1, Y2, Y3
B Y4, Y5
C X1, X2, Y3
C Y4, Z1, Z2
C Z3

All help will be nuch appreciated!!

Steve

 

[John... Visio MVP]

The following data needs to be placed in a preprinted report:

All help will be nuch appreciated!!

Steve

I can do that for you at a reasonable fee.

John... Visio MVP

 

[John... Visio MVP]

The following data needs to be placed in a preprinted report:

All help will be nuch appreciated!!

Steve

A "fur" report? Should not that be "wool" since you favourite activity is to
pull the the wool over the eyes of unsuspecting posters when you try to
fleece them?

John...

 

[Duane Hookom]

I would use a three column subreport on a main report. The main report record
source would only have the unique Assembly field values.

 

[Steve]

Thanks for responding, Duane!

What would be in the three columns of the subreport you suggest?

How would you write the query to return 2 records for Assembly B and three
records for Assembly C?

Steve

 

[Duane Hookom]

The three columns are defined in the Page Setup. The three columns would
display across then down.

The link Master/Child would be used to link the appropriate child/Components
for each master/Assembly. The subreport would display every related Component
in three columns and as many rows as it takes.

 

[Bob Quintal]

The following data needs to be placed in a preprinted report:
AssemblyID Assembly ComponentID Component
1 A 1
X1
1 A 2
X2
2 B 3
Y1
2 B 4
Y2
2 B 5
Y3
2 B 6
Y4
2 B 7
Y5
3 C 1
X1
3 C 2
X2
3 C 4
Y3
3 C 5
Y4
3 C 8
Z1
3 C 9
Z2
3 C 10
Z3

The components for a specific assembly need to be concatenated in
the preprinted report. There is only room for three components in
a line. When there are more than three components(Assembly B), the
next three components need to be placed in a second line. .And
when there are more than six components (Assembly C), The next
three components need to be placed in a third line. I need a query
that returns the following results for the above data:

A X1, X2
B Y1, Y2, Y3
B Y4, Y5
C X1, X2, Y3
C Y4, Z1, Z2
C Z3

All help will be nuch appreciated!!

Steve

You don't do this in a query, do it directly in the report.
Set a group header/footer to the assembly and create the detail session
to 1/3 rd of the page width, using the columns tab of the page setup
menu item. Play with the 'New Row or Col' property of the header &
footer to get what you want.

 

[Steve]

Thank you for your response!

Steve

You don't do this in a query, do it directly in the report.
Set a group header/footer to the assembly and create the detail session
to 1/3 rd of the page width, using the columns tab of the page setup
menu item. Play with the 'New Row or Col' property of the header &
footer to get what you want.

 

[Keith Wilby]

www.pcdatashit.com