Sum Function Problem

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

bomantas

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) an
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. Everytime
try something, I get an error returned. Hopefully someone can hel
because I'm going nuts!!!! The link to the site where to pull my sampl
database is:

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

thanks!!
 
bomantas said:
Hello again! I'm putting up a sample database that is based off my real
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 P
(Proposal), as well as set the date parameter for the time frame that
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 the
revenue into the footer of the report generated by the QBF. Everytime I
try something, I get an error returned. Hopefully someone can help
because I'm going nuts!!!! The link to the site where to pull my sample
database is:

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

thanks!!!
Click to expand...


You have to put a text box with a control source of =Sum([REVENUE]) in
the Report Footer, not the page footer.


HTH
 
Back
Top