Help with Format

[JS]

I am trying to create a report that looks like a report from excel.

I have two tables; tblProviders and tblBenefits

I want the report to look like this:
BC, DD, SS = Providers
Benefit Period, Waiting Period = Benefits

BC DD
SS
Benefit Period Half Year One Year Full Year
Waiting Period 7/9 12/9 9/9

I want the report to go across. Cross tab query didn't help me because I
have nothing to calculate/no data value.

I have tried everything. I tried subreport for BC, DD and SS but then the
report has a different amount of spacing and throughs the lines off in the
report.

Any suggestions are always welcomed!
JS

 

[KARL DEWEY]

Post sample data from Benefits show field names.

 

[JS]

tblProviders
lngProvidersID
strProvider

tblBenefitServices
lngBenefitServicesID
dtmDate
memBenefitPeriod
memDependentAgeLimit
memLifetimeMax

 

[KARL DEWEY]

Does lngProvidersID relate to lngBenefitServicesID?

You did not post a sample of your data. I do not see how the output
information you posted previously fits in the your tblBenefitServices table.