Hello once again -
This question is based on one that I previously asked yesterday,however it now concerns displaying a result of the amount of 'Yes' or 'No' selections returned from A field containing a Yes/No checkbox. I have a field called InOffice and would like to view the amount of 'Yes' results selected but having them displayed in the form of a single or double digit output in a separate text box. Can I use a similar format like the one below which I succesfully used from Taff for a record count total. I tried to do a similar thing with it in the control source of my text box but I am lost. I have looked at books,tried to construct a query and associate it with the text box control source, but unfortunately I am still stuck - any suggestions or guidance would be gratefully appreciated. Thanks to you all for the brilliant help that I have received so far ...
Previous Format Given:-
=Format(Dcount("Your Field Name Here","Your Table or Query Name Here"),"000")
Mavis
This question is based on one that I previously asked yesterday,however it now concerns displaying a result of the amount of 'Yes' or 'No' selections returned from A field containing a Yes/No checkbox. I have a field called InOffice and would like to view the amount of 'Yes' results selected but having them displayed in the form of a single or double digit output in a separate text box. Can I use a similar format like the one below which I succesfully used from Taff for a record count total. I tried to do a similar thing with it in the control source of my text box but I am lost. I have looked at books,tried to construct a query and associate it with the text box control source, but unfortunately I am still stuck - any suggestions or guidance would be gratefully appreciated. Thanks to you all for the brilliant help that I have received so far ...
Previous Format Given:-
=Format(Dcount("Your Field Name Here","Your Table or Query Name Here"),"000")
Mavis
