Grouping

[Jean-Paul]

HI...
Try to exlain this difficult problem (for me)

I have a table containing 4 fields:
code
description
header
value

The table contains about 1500 records
I launch a filter based upn value.
If value is true the I need the record

This results in about 32 records... so far no problem

The output of the records looks something ike this:

code description header

1.1 blabla1 whatever1
1.2 blabla2 whatever1
1.3 blabla3 whatever1
1.4 blabla4 whatever2
1.5 blabla5 whatever2

I can put this all in a continuous form which will look something like:

whatever1
1.1 blabla1
whatever1
1.2 blabla2
whatever1
1.3 blabla3
whatever2
1.4 blabla4
whatever2
1.5 blabla5

I want a form that looks something like:

whatever1
1.1 blabla1
1.2 blabla2
1.3 blabla3
whatever2
1.4 blabla4
1.5 blabla5

Can somebody please explain how this can be done?

Thanks
JP

 

[ruralguy via AccessMonster.com]

Have you tries sorting by the Header field 1st and then the code field 2nd?

 

[Jean-Paul]

That makes no difference...

I want the whatever1 line to appear only once and the moment the header
changes I want to see whatever2

JP

 

[ruralguy via AccessMonster.com]

That makes no difference...

I want the whatever1 line to appear only once and the moment the header
changes I want to see whatever2

JP

Have you tries sorting by the Header field 1st and then the code field 2nd?

[quoted text clipped - 50 lines]

 

[Jean-Paul]

It all has to do with a form, not a report...
So???? Not possible??
Thanks

That makes no difference...

I want the whatever1 line to appear only once and the moment the header
changes I want to see whatever2

JP

Have you tries sorting by the Header field 1st and then the code field 2nd?

[quoted text clipped - 50 lines]

Thanks
JP

 

[Mike Painter]

whatever1
1.1 blabla1
1.2 blabla2
1.3 blabla3
whatever2
1.4 blabla4
1.5 blabla5

Form with a subform is easy.
I don't think it can be done on a continuos form, certainly not without a
lot of code.

 

[Al Campagna]

Jean Paul,
Not for a form...

You could make a one record high subform to
accept just New records, and display all previously entered
records above it... as a subReport.
That might give you your "look," but, you wouldn't be able
to edit/delete previous records... just add new ones.
Not really practical...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

It all has to do with a form, not a report...
So???? Not possible??
Thanks

That makes no difference...

I want the whatever1 line to appear only once and the moment the header
changes I want to see whatever2

JP

Have you tries sorting by the Header field 1st and then the code field
2nd?

[quoted text clipped - 50 lines]
Thanks
JP