J
J.A.C.
Access 2003
I created an append query from a cross tab query - the objective is to add
the summed totals of five different categories to a Table which is used in an
input form and many reports – that calculates the five fields. The problem
is that when it appends to the table some of the fields are blank (no balance
in them) unless the fields have a value they will not calculate the total of
these fields. I have set the default “0†however when I append to the Table
the categories that do not have a value are blank and unless I manually input
the "o" the calculated will not work - it will also be blank.
Is there someway of adding the “o†values at the append query level?
I created an append query from a cross tab query - the objective is to add
the summed totals of five different categories to a Table which is used in an
input form and many reports – that calculates the five fields. The problem
is that when it appends to the table some of the fields are blank (no balance
in them) unless the fields have a value they will not calculate the total of
these fields. I have set the default “0†however when I append to the Table
the categories that do not have a value are blank and unless I manually input
the "o" the calculated will not work - it will also be blank.
Is there someway of adding the “o†values at the append query level?