Help with Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
tblProviders
lngProvidersID
strProvider

tblBenefitServices
lngBenefitServicesID
dtmDate
memBenefitPeriod
memDependentAgeLimit
memLifetimeMax
 
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.
 
Back
Top