Help!!

[oklahoma84]

I am making a database with tables that have the spending activitiy for each subaccount in a department. When I made a query only the records that had activity each month were displayed. For example, if account 110 had activity for Jan, Feb, and April it would not be displayed in the results at all. I would like it to display a zero or a blank for the month of march instead of omitting the record completely. Is there a way to do this.

Also, should I have each month's data in a different table or all uploaded into one table?

Thank you so much for any help ya'll can lend!!

 

[rainman89]

look up the nz function itll force a value and inturn show all results