OT Access gurus please help

Yahoo Archive
1
Thank you people. Worked fine today...;-)

Darren Mann
IT Manager
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222


_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
sarah.vareschi@...
Sent: Tuesday, April 17, 2007 2:44 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] OT Access gurus please help



On your report summary, add a new text box with following formula:
=Sum(IIf([booleanfi-eld]=True,-1,0)) (obviously replacing [booleanfield]
with your field name on your report.

-----Original Message-----
From: HYPERLINK "mailto:vantage%40yahoogroups.com"vantage@...
[mailto:HYPERLINK
"mailto:vantage%40yahoogroups.com"vantage@...] On Behalf
Of Darren Mann
Sent: Tuesday, April 17, 2007 3:26 PM
To: Vantage User Group (HYPERLINK
"mailto:vantage%40yahoogroups.com"vantage@...)
Subject: [Vantage] OT Access gurus please help

I've been banging my head here with such a simple task that won't work
in MS
Access. I have defined 3 fields in my table as boolean and placed them
on
my form as check boxes. Now I'm trying to do a summary report counting
the
occurences of each field having been checked/YES. Nothing is working.
I've
tried adding a field to convert to a 1 or 0 and sum the resulting values
and
I can not get the sum or count functions to work. This is driving me
crazy
on a monday.

Darren Mann
IT Manager
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 269.5.1/764 - Release Date: 4/17/2007
4:43 AM



[Non-text portions of this message have been removed]

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
HYPERLINK
"http://groups.yahoo.com/group/vantage/files/."http://groups.-yahoo.com/-gro
up/vantage/-files/.
(2) To search through old msg's goto:
HYPERLINK
"http://groups.yahoo.com/group/vantage/messages"http://groups.-yahoo.com/-gr
oup/vantage/-messages
(3) To view links to Vendors that provide Vantage services goto:
HYPERLINK
"http://groups.yahoo.com/group/vantage/links"http://groups.-yahoo.com/-group
/vantage/-links
Yahoo! Groups Links






--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 269.5.1/764 - Release Date: 4/17/2007
4:43 AM



--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 269.5.2/766 - Release Date: 4/18/2007
7:39 AM



[Non-text portions of this message have been removed]
2
I've been banging my head here with such a simple task that won't work in MS
Access. I have defined 3 fields in my table as boolean and placed them on
my form as check boxes. Now I'm trying to do a summary report counting the
occurences of each field having been checked/YES. Nothing is working. I've
tried adding a field to convert to a 1 or 0 and sum the resulting values and
I can not get the sum or count functions to work. This is driving me crazy
on a monday.

Darren Mann
IT Manager
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222




--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 269.5.1/764 - Release Date: 4/17/2007
4:43 AM




[Non-text portions of this message have been removed]
3
Try building a query with syntax like this -

SELECT Sum([a]*-1) AS [Sum of a], Sum([b]*-1) AS [Sum of b], Sum([c]*-1)
AS [Sum of c]
FROM aaa;

May get you closer.
Jeff

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Darren Mann
Sent: Tuesday, April 17, 2007 2:26 PM
To: Vantage User Group (vantage@yahoogroups.com)
Subject: [Vantage] OT Access gurus please help



I've been banging my head here with such a simple task that won't work
in MS
Access. I have defined 3 fields in my table as boolean and placed them
on
my form as check boxes. Now I'm trying to do a summary report counting
the
occurences of each field having been checked/YES. Nothing is working.
I've
tried adding a field to convert to a 1 or 0 and sum the resulting values
and
I can not get the sum or count functions to work. This is driving me
crazy
on a monday.

Darren Mann
IT Manager
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 269.5.1/764 - Release Date: 4/17/2007
4:43 AM



[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
4
On your report summary, add a new text box with following formula:
=Sum(IIf([booleanfield]=True,1,0)) (obviously replacing [booleanfield]
with your field name on your report.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Darren Mann
Sent: Tuesday, April 17, 2007 3:26 PM
To: Vantage User Group (vantage@yahoogroups.com)
Subject: [Vantage] OT Access gurus please help

I've been banging my head here with such a simple task that won't work
in MS
Access. I have defined 3 fields in my table as boolean and placed them
on
my form as check boxes. Now I'm trying to do a summary report counting
the
occurences of each field having been checked/YES. Nothing is working.
I've
tried adding a field to convert to a 1 or 0 and sum the resulting values
and
I can not get the sum or count functions to work. This is driving me
crazy
on a monday.

Darren Mann
IT Manager
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222




--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 269.5.1/764 - Release Date: 4/17/2007
4:43 AM




[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
5
Replace the Yes condition with "-1"



Gerard M Wadman

Sr. Network Systems Engineer



Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460



978/486-4088 x 124

978/486-4108 (fax)



http://www.scandius.com/





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Darren Mann
Sent: Tuesday, April 17, 2007 3:26 PM
To: Vantage User Group (vantage@yahoogroups.com)
Subject: [Vantage] OT Access gurus please help



I've been banging my head here with such a simple task that won't work
in MS
Access. I have defined 3 fields in my table as boolean and placed them
on
my form as check boxes. Now I'm trying to do a summary report counting
the
occurences of each field having been checked/YES. Nothing is working.
I've
tried adding a field to convert to a 1 or 0 and sum the resulting values
and
I can not get the sum or count functions to work. This is driving me
crazy
on a monday.

Darren Mann
IT Manager
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
Ph. 641-342-2103
Fax 641-342-3222

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 269.5.1/764 - Release Date: 4/17/2007
4:43 AM



[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]