I have developed a database to monitor deposits of my drivers. I have built a query to give me route number, date, beginning balance owed, amountdue, amount cleared, bank adjustments, ending balance. The ending balance is a formual that should be beginning balance + amount due + amount cleared + bank adjustments. However, when I view the query, the box is empty. Does anyone have a suggestion as to what could be the problem?

My guess is that one of the values gathered by your query (beginning balance, amount due, amount cleared or bank adjustment) may be null (non-existant).

a+null=null

Eventually use nz(variable, value if null)
Ex: nz([beginning balance], 0)+ nz([amount due], 0)...

Alex