|
 |
access thread: Check Boxes Count in Reports
Message #1 by gail711@g... on Tue, 19 Mar 2002 16:21:15
|
|
Help, I have a report that has several check boxes in it. How do i get a
sum of the ticked check boxes (am currently using =sum([checkbox]) in
control property). My results are minus numbers at the moment (obviously
because the value is 0 or -1). is there any way i can get round this
problem and make the value positive??
Thanks
Message #2 by Omar Chaudry <OChaudry@b...> on Tue, 19 Mar 2002 16:31:52 -0000
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1CF63.932E46C0
Content-Type: text/plain
How about the abs() function?
-----Original Message-----
From: gail711@g... [mailto:gail711@g...]
Sent: 19 March 2002 16:21
To: Access
Subject: [access] Check Boxes Count in Reports
Help, I have a report that has several check boxes in it. How do i get a
sum of the ticked check boxes (am currently using =sum([checkbox]) in
control property). My results are minus numbers at the moment (obviously
because the value is 0 or -1). is there any way i can get round this
problem and make the value positive??
Thanks
DISCLAIMER: The information in this message is confidential and may be
legally privileged. It is intended solely for the addressee. Access to this
message by anyone else is unauthorised. If you are not the intended
recipient, any disclosure, copying, or distribution of the message, or any
action or omission taken by you in reliance on it, is prohibited and may be
unlawful. Please immediately contact the sender if you have received this
message in error. Thank you.
Message #3 by ProDev <prodevmg@y...> on Tue, 19 Mar 2002 08:44:40 -0800 (PST)
|
|
--0-1620332960-1016556280=:24930
Content-Type: text/plain; charset=us-ascii
Change the sign in On Format event. Just a thought.
gail711@g... wrote: Help, I have a report that has several check boxes in it. How do i get a
sum of the ticked check boxes (am currently using =sum([checkbox]) in
control property). My results are minus numbers at the moment (obviously
because the value is 0 or -1). is there any way i can get round this
problem and make the value positive??
Thanks
Lonnie Johnson, ProDev, Builders of MS Access Databases
Let us build your next MS Access database application.
http://www.galaxymall.com/software/PRODEV
Send and Receive payments for free with PayPal: http://www.paypal.com/refer/pal=Y6TYF7YF8E2JG
---------------------------------
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
Message #4 by "Gerald, Rand" <RGerald@u...> on Tue, 19 Mar 2002 13:52:11 -0600
|
|
You could multiply the result by -1.
Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: gail711@g... [mailto:gail711@g...]
Sent: Tuesday, March 19, 2002 10:21 AM
To: Access
Subject: [access] Check Boxes Count in Reports
Help, I have a report that has several check boxes in it. How do i get
a
sum of the ticked check boxes (am currently using =3Dsum([checkbox]) in
control property). My results are minus numbers at the moment
(obviously
because the value is 0 or -1). is there any way i can get round this
problem and make the value positive??
Thanks
Message #5 by joe.dunn@c... on Wed, 20 Mar 2002 09:06:44 +0000
|
|
Assuming your report is based on a query, add an expression to the query
such as:
CheckTotals: IIf([YourTable]![Checkbox]=True,1,0)
then in the report, add a control in the relevant footer
=Sum(CheckTotals)
Joe Dunn
gail711@g...
m To: "Access" <access@p...>
cc:
19/03/2002 Subject: [access] Check Boxes Count in
16:21 Reports
Please
respond to
"Access"
Help, I have a report that has several check boxes in it. How do i get a
sum of the ticked check boxes (am currently using =sum([checkbox]) in
control property). My results are minus numbers at the moment (obviously
because the value is 0 or -1). is there any way i can get round this
problem and make the value positive??
Thanks
*************************************************************************
This e-mail may contain confidential information or be privileged. It is intended to be read and used only by the named
recipient(s). If you are not the intended recipient(s) please notify us immediately so that we can make arrangements for its return:
you should not disclose the contents of this e-mail to any other person, or take any copies. Unless stated otherwise by an
authorised individual, nothing contained in this e-mail is intended to create binding legal obligations between us and opinions
expressed are those of the individual author.
The CIS marketing group, which is regulated for Investment Business by the Financial Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R - for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965 - for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number 3390839 - for ISAs and investment products bearing the CIS
name
Registered offices: Miller Street, Manchester M60 0AL Telephone 0161-832-8686 Internet http://www.cis.co.uk E-mail
cis@c...
CIS Deposit and Instant Access Savings Accounts are held with The Co-operative Bank p.l.c., registered in England and Wales number
990937, P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS Policyholder Services Limited as agent of the
Bank.
CIS is a member of the General Insurance Standards Council
CIS & the CIS logo (R) Co-operative Insurance Society Limited
********************************************************************************
|
|
|
View Cart
