I am a self-taught Access97 worker with gaps in my learning, so please have mercy! I have a query based on a crosstab query. In the query I have a calculated field
Tot:[Jul]+ [Aug]
Works fine unless Jul or Aug is blank, then returns nothing; that is, won't return the Aug amount. Jul and Aug are formatted as currency. Could someone point me in the direction of a solution?
Tot:[Jul]+ [Aug]
Works fine unless Jul or Aug is blank, then returns nothing; that is, won't return the Aug amount. Jul and Aug are formatted as currency. Could someone point me in the direction of a solution?