S
screen245
I am trying to have a field in a report total the amount from two fieldsby
account number. This is a report on profitablility of each job. I am trying
to add freight cost into revenue for a total. I have my query and it shows
the proper totals with the correct job numbers. my issue is the report
totals the frioeght charges and puts that number in all of the job numbers
revenue field. I need to know how to get this to fill them in by job number
and if there is no data add zero.
here is the string in my report
=Sum([Revenue]+[qryGLIDFreight]![GLIDTotal])
I know i am missing something i am just not sure what it is i need to tell
it to use the job number as well. I don't do much access programing but the
CFO asked me to do this for him. I am 90% there. and of course my books are
at home...
thanks in advance
account number. This is a report on profitablility of each job. I am trying
to add freight cost into revenue for a total. I have my query and it shows
the proper totals with the correct job numbers. my issue is the report
totals the frioeght charges and puts that number in all of the job numbers
revenue field. I need to know how to get this to fill them in by job number
and if there is no data add zero.
here is the string in my report
=Sum([Revenue]+[qryGLIDFreight]![GLIDTotal])
I know i am missing something i am just not sure what it is i need to tell
it to use the job number as well. I don't do much access programing but the
CFO asked me to do this for him. I am 90% there. and of course my books are
at home...
thanks in advance