Acess 2000 report with multiple sum values

From: "Todd Spear" <Todd Spear@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 8 Aug 2005 22:43:02 -0700

I have a report that has 32 entries bound to a current table. I need to sun
all of thesse values basd on a where clause. I Tries DSUM function but
apparently there is only 255 characters allowed per DSUM string?

In good database design - totals are NOT stored in tables but I do not know
how to solve this problem?

Is there a way to set report values -- mostly textboxes - via code and then
print. I have a form that collects the where clause parameters.

Thanks in advance

Todd
.

Follow-Ups:
- Re: Acess 2000 report with multiple sum values
  - From: Allen Browne

Prev by Date: Re: How to get rid of 3 "border looking" boxes on a report?
Next by Date: Re: Omit nickname in concatenated field
Previous by thread: Report Subtotals - Repost - Thanks!
Next by thread: Re: Acess 2000 report with multiple sum values
Index(es):
- Date
- Thread

Relevant Pages

Re: Report Parameters - no results
... Is it indicated in the correct spot of my WHERE clause? ... be able to use it for this particular report based on user needs. ... What else can I do to try to correct my sql? ... used with function in query expression" for my where clause. ...
(microsoft.public.access.reports)
RE: Passing Qry as part of Rpt DoCmd.OpenReport
... You are, by your description, trying to filter the output of the report. ... If you create a string that is a Where Clause without the word Where, ... And yes my data query is plain vanillia with no where clause only a single ...
(microsoft.public.access.reports)
Re: Report Parameters - no results
... The WHERE clause I posted earlier is the only suggestion I have if you want to continue with that approach. ... be able to use it for this particular report based on user needs. ... What else can I do to try to correct my sql? ... > used with function in query expression" for my where clause. ...
(microsoft.public.access.reports)
Re: Change query from application on the fly?
... I build the SQL query and pass it to the Crystal ... What happens when you use parameters in the where clause? ... options in the the report options. ... overwrite the command though. ...
(microsoft.public.vb.crystal)
Re: For Marshall Barton
... additional subreports into the same detail section of the main report. ... Control Source: ABegBal ... named the subreport control to make it look like a text box ... "The LEVEL clause includes a reserved word or argument that is misspelled or ...
(microsoft.public.access.reports)