CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Best way to TOTAL a field in a transaction table where userid matches a given criteria?

Print topic Send  topic

Author Message
Don Oldenburg
Posted: 08/08/2001, 3:05 PM

Best way to TOTAL a field in a transaction table where userid matches a
given criteria?


CodeCharge
Posted: 08/08/2001, 3:42 PM

Please look at the BookStore example, which shows Order Total.

"Don Oldenburg" <don.oldenburg@cacmnet.com> wrote in message
news:9ksd3d$l5q$1@news.codecharge.com...
> Best way to TOTAL a field in a transaction table where userid matches a
> given criteria?
>
>
>

Don Oldenburg
Posted: 08/08/2001, 3:44 PM

Yup, I was able to find it in the ledger example also.

NOW -- my problem is to create a screen which gives sum by users to be
viewed by administration. Summing by one employee, only his/her
transactions was fairly easy... any further thoughts on how to implement
something which will do the same thing, but in a broader level -- for all
employees, on one screen/report?

DOn


"CodeCharge" <support@codecharge.com> wrote in message
news:9ksf8d$pfa$1@news.codecharge.com...
> Please look at the BookStore example, which shows Order Total.
>
> "Don Oldenburg" <don.oldenburg@cacmnet.com> wrote in message
>news:9ksd3d$l5q$1@news.codecharge.com...
> > Best way to TOTAL a field in a transaction table where userid matches a
> > given criteria?
> >
> >
> >
>
>

Alexey Alexapolsky
Posted: 08/13/2001, 6:18 AM

there was somewhere a newsgroup article how to make such reports in CC by
Ken Hardwick

--
Alex

Don Oldenburg <don.oldenburg@cacmnet.com> wrote in message
news:9ksfbr$pjr$1@news.codecharge.com...
> Yup, I was able to find it in the ledger example also.
>
> NOW -- my problem is to create a screen which gives sum by users to be
> viewed by administration. Summing by one employee, only his/her
> transactions was fairly easy... any further thoughts on how to implement
> something which will do the same thing, but in a broader level -- for all
> employees, on one screen/report?
>
> DOn
>
>
> "CodeCharge" <support@codecharge.com> wrote in message
>news:9ksf8d$pfa$1@news.codecharge.com...
> > Please look at the BookStore example, which shows Order Total.
> >
> > "Don Oldenburg" <don.oldenburg@cacmnet.com> wrote in message
> >news:9ksd3d$l5q$1@news.codecharge.com...
> > > Best way to TOTAL a field in a transaction table where userid matches
a
> > > given criteria?
> > >
> > >
> > >
> >
> >
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.