I am working on an access report that displays records depending on the conditions of multiple fields from a query. If ([date1] <= [date2]) and [fieldA] is false, then the report needs to have one heading with the applicable data listed in the details section. Following those records, the heading needs to change for the next bunch of data ([fieldA] is true). At the end of those records, the heading changes again for the 3rd set of data ([date1] > [date2]) and [fieldA] is false. The fields in the report are the same for each of the 3 sections. It should look something like this:
Report Header (once at the beginning)
Section Header 1 (depends on section condition)
First Group of Records ([Employee] field)
Fld1 Fld2 Fld3 (records 4 that employee)
.
.
.
Second Group of Records
Field1 Field2 Field3
.
.
.
Section Header 2
First Group of Records
Field1 Field2 Field3
.
.
.
Second Group of Records
Field1 Field2 Field3
.
.
.
Section Header 3
First Group of Records
Field1 Field2 Field3
.
.
.
Second Group of Records
Field1 Field2 Field3
.
.
.
I’m confused over where to put the conditions (and the proper syntax) to change the header and to extract the correct data for the section.
