SubReportTwoColBalanced DB by A.D. Tejpal

[Kbrad32 via AccessMonster.com]

Has anyone use this sample DB with success in converting the subreport to
view Down and Across? I played around with it but I have no clue in what I am
doing. Any response will be greatly appreciate.

Kbrad32

 

[Duane Hookom]

I'm not sure how A.D. set this up but he generally explains things fairly
well. I expect the Record Source of the report had a calculated column that
provided the pseudo sort order. Did you ever try the solution/sql I suggested
to you about 10 days ago?

 

[Kbrad32 via AccessMonster.com]

Yes, I did I was unable to get the records to view as down an across. The SQL
pulled the records with a COL column inserted in the query, but still no
change.

SubReportTwoColBalanced DB by A.D. Tejpal - duanehooko
02-Nov-08 11:04:00

I'm not sure how A.D. set this up but he generally explains things fairly
well. I expect the Record Source of the report had a calculated column that
provided the pseudo sort order. Did you ever try the solution/sql I suggested
to you about 10 days ago?

 

[Kbrad32 via AccessMonster.com]

Is it possible to send you a sample of my DB?

I'm not sure how A.D. set this up but he generally explains things fairly
well. I expect the Record Source of the report had a calculated column that
provided the pseudo sort order. Did you ever try the solution/sql I suggested
to you about 10 days ago?

 

[Duane Hookom]

email me for directions on how to do this
DuaneHookom AT gmail DOT com

 

[Kbrad32 via AccessMonster.com]

//

 

[Duane Hookom]

The calculated column was creating the appropriate value but the subreport
didn't have any sorting or grouping. The subreport needed to have the sorting
and grouping set to:
[Col]
=Left(Ingredient,255)
The left() function was needed since Ingredient is a memo field which can't
be used for sorting.

 

[Kbrad32 via AccessMonster.com]

Thanks for your help, Mr Hookom. One more question, if I were to break down
the my ingredient table further (ie. separate columns for the Amount, Units
of Measure, & Ingredient will your SQL technique work or will that be to much
for the sorting & Grouping?

The calculated column was creating the appropriate value but the subreport
didn't have any sorting or grouping. The subreport needed to have the sorting
and grouping set to:
[Col]
=Left(Ingredient,255)
The left() function was needed since Ingredient is a memo field which can't
be used for sorting.

//

 

[Duane Hookom]

The number of text boxes in the detail section won't make any difference. You
would not do anything different with the sorting and grouping or page layout,
just add more text boxes to fit within the width of the column.
--
Duane Hookom
Microsoft Access MVP

Thanks for your help, Mr Hookom. One more question, if I were to break down
the my ingredient table further (ie. separate columns for the Amount, Units
of Measure, & Ingredient will your SQL technique work or will that be to much
for the sorting & Grouping?

The calculated column was creating the appropriate value but the subreport
didn't have any sorting or grouping. The subreport needed to have the sorting
and grouping set to:
[Col]
=Left(Ingredient,255)
The left() function was needed since Ingredient is a memo field which can't
be used for sorting.

//