Detail section (Continuous)

[Sniper-BoOyA-]

Good morning,

Ive got a (small) question regarding the detail section on a report, which is acting like a continuous report.

Ive got a total of 4 records. Each record has a sample number. Ive calculated the average of sample number 1 and 2, 3 and 4.

At the moment it looks like this:

Samplenr____ Value ____ Average

1....................3.................2.5
2....................2.................2.5
3....................7...................3
4....................3...................5

I can say in the query i want to display the average if sample number is 1 and 3.

Samplenr____ Value ____ Average

1....................3.................2.5
2....................2.....................
3....................7...................3
4....................3....................

But then i have 2 empty fields on the report.

My question, is it possible to combine the Average field and present it as one, but with the height of 2?

So lets say, originally the fields have a height of 0.4cm

My goal: Combine the 2 fields with the same average, and present it with a height of 0.4cm.

I am afraid i allready know the answer, but i just want to be sure.

Anyway, i'd like to thank you in advance for the time and effort.

Cheers!

 

[vbaInet]

At the moment it looks like this:

Samplenr____ Value ____ Average

1....................3.................2.5
2....................2.................2.5
3....................7...................3
4....................3...................5

So, based on the above what would you like the result to be?

 

[Sniper-BoOyA-]

So, based on the above what would you like the result to be?

Sorry for the late reply. What im trying to achieve is :

Samplenr____ Value ____ Average

1....................3.................2.5
2....................2.................
3....................7...................3
4....................3.................

But the average for sample 1 and 2 in 1 single textbox. But with the height of 2 textboxes.

See attached (excel) screenshot for clarification.

 

[vbaInet]

Do you know about the Hide Duplicates property?