How to pickup a data???

[latestgood]

Hello,

I am creating after school program but had question in regards to finding remaining balance. I have two tables. First table consists of categories (Basketball, Soccer, Football) and budget for that category. Second tables consists of expenses for each category. The problem I am having is that if there is no expense report to a category, the query will ignore the null category. How can I pick up the category that has no matching expense report. For example, if I give budget of $1000 for basketball, and if I do not have expense for basketball, I still want the query to show the $1000 remaining balance.

 

[WineSnob]

Working with null can be a pain. I am sure someone here can help with that but in the meantime you can add an expense with the value of 0 zero in the category basketball. That should allow you to subtract zero from 1000 and give you 1000.
HTH