Recent content by explopyro

I've tried the Nz function and it doesn't seem to work. Perhaps I'm using the syntax wrong; is there a certain way it needs to be used with an aggregate in a query? My other thought, which I haven't tried yet, is that I could require the creation of dummy entries in the database with a value of...

I'm having a problem with queries, and I can't seem to find a solution in books - I looked through about ten of them and none of them addressed the problem. This may be because it has a painfully obvious solution... A little background: I am designing a database for a debt-collection law firm...