My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Sum's In Reports, Office 2003
|
|
 Apr 6 2012, 01:04 PM
Post
#1
|
|
|
UtterAccess Addict Posts: 273 From: Columbus, Ohio  |
Hello,
I'm trying to come up with a total count of results equal to: 1weekday and 9 holes. I can't seem to find an IF statement that works. Any help would be great. Thank you!! =Sum(IIf([Weekend/Weekday]="1Weekday" And [Holes]="9",1,0)) If you need any further information please let me know!! |
 |
 
|
|
Apr 6 2012, 01:16 PM
Post
#2
|
|
|
Access Wiki and Forums Moderator Posts: 47,962 From: SoCal, USA |
Hi Shane,
Is [Holes] a text or numeric field? And, where are you placing your textbox on the report? Just my 2 cents... (IMG:style_emoticons/default/2cents.gif) |
|
|
|
|
Apr 6 2012, 01:24 PM
Post
#3
|
|
|
UtterAccess Addict Posts: 273 From: Columbus, Ohio |
Hi DBguy and thanks for the help!!
Holes is "numeric" and I'm sorting by a field called "Category". I'm placing this expression in the footer of "Category". Let me know if you need more. |
|
|
|
|
Apr 6 2012, 01:37 PM
Post
#4
|
|
|
Access Wiki and Forums Moderator Posts: 47,962 From: SoCal, USA |
Hi Shane,
If [Holes] is numeric, then you don't need to enclose the value in quotes. Try the following and let us know what you get: =Sum(IIf([Weekend/Weekday]="1Weekday" And [Holes]=9,1,0)) Just my 2 cents... (IMG:style_emoticons/default/2cents.gif) |
|
|
|
|
Apr 6 2012, 01:53 PM
Post
#5
|
|
|
UtterAccess Addict Posts: 273 From: Columbus, Ohio |
Thanks again DBguy!! Your the BEST (IMG:style_emoticons/default/notworthy.gif)
|
|
|
|
|
Apr 6 2012, 02:20 PM
Post
#6
|
|
|
Access Wiki and Forums Moderator Posts: 47,962 From: SoCal, USA |
Hi Shane,
(IMG:style_emoticons/default/yw.gif) We are happy to help. (IMG:style_emoticons/default/thanks.gif) Good luck with your project. |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 22nd May 2013 - 02:15 AM |