Help with report

J

JudyT

I have a few queries in one report and by the time i add the last query to
it, it says its too complex.

My question is this...
I have two fields on a report which is a sum of a count. I want to add
these two fields together to get a total. I tried doing the build function
with the two fields and =Sum[name of the table].[name of the field]+[name of
the table].[name of the field] and it returns a blank field. Can someone
help me please...I am pulling out all my hair. What little is left after
dealing and learning ACCESS.
JudyT
 
K

KARL DEWEY

If you are using queries in a report then you need to use those queries to
get your total like this --
=Sum[name of the Query].[name of the field]+[name of the Query].[name of
the field]

But how are you using two queries as the record source?
 
J

JudyT

I resolved this issue, thanks for your help.

KARL DEWEY said:
If you are using queries in a report then you need to use those queries to
get your total like this --
=Sum[name of the Query].[name of the field]+[name of the Query].[name of
the field]

But how are you using two queries as the record source?

--
KARL DEWEY
Build a little - Test a little


JudyT said:
I have a few queries in one report and by the time i add the last query to
it, it says its too complex.

My question is this...
I have two fields on a report which is a sum of a count. I want to add
these two fields together to get a total. I tried doing the build function
with the two fields and =Sum[name of the table].[name of the field]+[name of
the table].[name of the field] and it returns a blank field. Can someone
help me please...I am pulling out all my hair. What little is left after
dealing and learning ACCESS.
JudyT
Click to expand...
Click to expand...
 
Top