Summarize in Report

  • Thread starter Thread starter bomantas
  • Start date Start date
B

bomantas

I have a Query by form in which I use to sort my data. I have in th
report that is generated by my Query by Form a column with revenu
amounts in it. But now what I want is when I generate a report, I wan
a text box in the footer of my report that displays the total of th
revenues that I pulled up from my Query by Form. I tried creating
second query that calculates the revenue field and then linking that t
my report, but everytime I try to run my report, it tells me to ente
the parameter for that revenue summary box and I just hit okay and i
displays an error message. I don't know what to do and never though
adding would be this difficult.

Frustrate
 
Insert a text box in your report footer.Enter the formula " =sum(SumofTEXTBOX) where SumofTEXTBOX = your summed revenue field

----- bomantas wrote: ----


I have a Query by form in which I use to sort my data. I have in th
report that is generated by my Query by Form a column with revenu
amounts in it. But now what I want is when I generate a report, I wan
a text box in the footer of my report that displays the total of th
revenues that I pulled up from my Query by Form. I tried creating
second query that calculates the revenue field and then linking that t
my report, but everytime I try to run my report, it tells me to ente
the parameter for that revenue summary box and I just hit okay and i
displays an error message. I don't know what to do and never though
adding would be this difficult.

Frustrate
 
Hello again! I'm putting up a sample database that is based off my rea
one that I am having problems with. In it is my QBF (Query-By-Form
and in order to use this form, you must choose either D(definite) or
(Proposal), as well as set the date parameter for the time frame tha
you wish to pull records for (First Date 01/01/04, Last Date 04/30/04)
What I'm having problems with is trying to put a grand total of th
revenue into the footer of the report generated by the QBF. Everytim
I try something, I get an error returned. Hopefully someone can hel
because I'm going nuts!!!! The link to the site where to pull m
sample database is:

http://bomantas.0catch.com/2004DatBase.zip

thanks!!!:cool: :cool
 
Back
Top