Nz function

[linda]

I'm trying to complete a report using 2 different queries. 1) Budget (gives
names and amount of money they have to spend) 2) Transactions (tells all
expenditures during their budget year.)
How can I set this up so that the Balance ( which I set up in the report)
will show a zero balance or the expenditures will show a zero if no
transactions took place for that person. And where do I enter this? In the
querie? I've tried several different ways but nothing seems to work.

This is what I want

LName Budget Amount Expenditure Balance
Jane Doe $800.00 0 $800.00

Should I be doing a cross tab? Should I be putting the Balance column in
the querie? Get the black board and chaulk out people and draw me a picture.
I've been weeks trying to figure this out.

 

[Rene T]

One way you can do this is in your transaction query pulling the expenditures
using the following: Exp1: IIf(IsNull([Expenditure]),0,[Expenditure])

Link the budget query with the expenditure query (pulling the field Exp1) in
a third query that is the data source for the report.

Good Luck,
Rene

 

[linda]

Thank you--You make it seem so easy. It worked.

One way you can do this is in your transaction query pulling the expenditures
using the following: Exp1: IIf(IsNull([Expenditure]),0,[Expenditure])

Link the budget query with the expenditure query (pulling the field Exp1) in
a third query that is the data source for the report.

Good Luck,
Rene

I'm trying to complete a report using 2 different queries. 1) Budget (gives
names and amount of money they have to spend) 2) Transactions (tells all
expenditures during their budget year.)
How can I set this up so that the Balance ( which I set up in the report)
will show a zero balance or the expenditures will show a zero if no
transactions took place for that person. And where do I enter this? In the
querie? I've tried several different ways but nothing seems to work.

This is what I want

LName Budget Amount Expenditure Balance
Jane Doe $800.00 0 $800.00

Should I be doing a cross tab? Should I be putting the Balance column in
the querie? Get the black board and chaulk out people and draw me a picture.
I've been weeks trying to figure this out.