Display group header w/no details

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

Guest

I have a report in Access 2000 that is based on a query containing 3 tables
(payment information) with a subreport based on one table (grant budget by
item). The query has a parameter to limit the data to one grant. The report
is grouped on budget items. The body contains payment details against the
budgeted items.

Grant #

BudgetItem1 BudgetedAmount
PaymentDate PaymentMade
PaymentDate PaymentMade
TotalPaid BudgetRemaining

I need the group header and footer to show the Budget Item if no payment has
been made. Any help would be greatly appreciated
 
Hi,

I think you need to go back to your query(s) and get them
to display the budget info even if there are no payments.
Depending on your table structure and query design try
double clicking the join between budgetID and the payments
table and select "display all budget stuff and only
payments where equal". When you get the results you want
in your query you stand a chance of getting it right in
the report.

HTH

Terry
 
Back
Top