2 different detail formats

[Kevin]

Is there a way to show 2 different detail formats on the
same report? For example: I have 20 categories divided
into 4 different groups. All but the last category in
each group is a Number field which I need to appear on the
report as a columnar or datasheet type view. The last
category in each group stores data in a Memo field and I'd
like to show on the report as text/paragraph.

So I'd like it to appear as:
Group1
Category1 # # # #
Category2 # # # #
Category3 # # # #
Category4 # # # #
Category5(notes) "Here is where remarks would be.."
Group2
Category6 # # # #
Category7 # # # #
Category8 # # # #
Category9 # # # #
Category10(notes) "Here is where remarks would be.."
Group3
etc...

Any suggestions? Any help is greatly appreciated!

 

[Kevin]

Jim,
Each record has either numbers OR notes, and I originally
planned on storing all notes in a different table, but
figured that wouldn't really benefit since I need it to
attach itself to the end of the of each grouping and
wanted the report to sort details in proper order. Am I
missing something, or is there some VB code that would
sort it correctly?
Thanks again!
Kevin

 

[Jim/Chris]

Could you post your table(s) definition

Jim

-----Original Message-----
Jim,
Each record has either numbers OR notes, and I originally
planned on storing all notes in a different table, but
figured that wouldn't really benefit since I need it to
attach itself to the end of the of each grouping and
wanted the report to sort details in proper order. Am I
missing something, or is there some VB code that would
sort it correctly?
Thanks again!
Kevin

.

 

[Kevin]

I have an Employee table (self explanatory), then a
EvalNumber table which has the eval number, the date, and
the type of evaluation, then the Rating table which is has
the following fields:
Employee(many side of one to many)
Eval#(many side of one to many)
CategoryID
Improving (number field - rating system from 0-4)
StayingTheSame (number field)
Regressing (number field)
Remarks (memo field)

An item of note is that in another table there is a
GroupID which groups certain categories. So CategoryID #1
thru 8 may be with GroupID 1, and CategoryID #9 thru 15
may be with GroupID 2. My initial thought is that to keep
the Remarks field sorted to accompany the ratings in each
group, I need to keep the CategoryID in order and have the
last number (such as #8, #15, etc.) that belongs to a
group be the Remarks. It all seems to work great, except
for trying to display the different data types on the
reports.
Thanks again!
Kevin