M mickeyboy New member Local time Yesterday, 21:46 Joined Jun 7, 2013 Messages 8 Sep 3, 2013 #1 I have been stuck trying to write an expression that will calculate the Yes values in a range of 16 Yes/No fields. I have attached a screen print of the report I am working on. Hoping for some help!!! Attachments Figure 1_Register Report.zip Figure 1_Register Report.zip 288.7 KB · Views: 106
I have been stuck trying to write an expression that will calculate the Yes values in a range of 16 Yes/No fields. I have attached a screen print of the report I am working on. Hoping for some help!!!
pr2-eugin Super Moderator Local time Today, 05:46 Joined Nov 30, 2011 Messages 8,494 Sep 3, 2013 #2 Is this a Report? If so what is the RecordSource of the Report?
MarkK bit cruncher Local time Yesterday, 21:46 Joined Mar 17, 2004 Messages 8,463 Sep 3, 2013 #3 Yes = -1, and No = 0, so . . . Code: SELECT -Sum(MyYesNoField) As YesCount FROM table
M mickeyboy New member Local time Yesterday, 21:46 Joined Jun 7, 2013 Messages 8 Sep 3, 2013 #4 The reports source is a form called register
M mickeyboy New member Local time Yesterday, 21:46 Joined Jun 7, 2013 Messages 8 Sep 3, 2013 #5 The record source is a form called Report
M mickeyboy New member Local time Yesterday, 21:46 Joined Jun 7, 2013 Messages 8 Sep 3, 2013 #6 Didn't work!! I'm just looking for an expression to enter into an unbound text box. I am a real newbie at this
Didn't work!! I'm just looking for an expression to enter into an unbound text box. I am a real newbie at this
