 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / November 2005currency field to appear in report as check box/true false
I have a number/currency field that I would like to have appear as a check box on a report, and am unable to do this in the query or the report. The data is appearing on the report as a number. Any way this can be done? I look forward to your suggestions. Thanks so much in advance. Cheers. A checkbox can have a value of True, False, or Null (for when the checkbox has its Triple State property set to Yes). So, what are the values in your number/currency field? Are they Null, 0, or -1 (Null, False, True respectively)? If not, then what is the checkbox supposed to show if the value is, say, $50.00?  SignatureKen Snell <MS ACCESS MVP> >I have a number/currency field that I would like to have appear as a check > box on a report, and am unable to do this in the query or the report. The > data is appearing on the report as a number. Any way this can be done? I > look forward to your suggestions. > > Thanks so much in advance. Cheers. > I have a number/currency field that I would like to have appear as a check > box on a report, and am unable to do this in the query or the report. The > data is appearing on the report as a number. Any way this can be done? I > look forward to your suggestions. > > Thanks so much in advance. Cheers. I don't understand. A Number/Currency field can contain a wide range of number values; a Check Box value can only contain be -1 or 0. What are you trying to do? SignatureFred Please respond only to this newsgroup. I do not reply to personal e-mail If we have started paying out funds for a certain project, the amount(s) are entered into the database. I summed them in a query for other reports that show how much has been paid out (eg. $12,000), but for this most recent report, I do not want to show an amount paid to date (whick is currently appearing in my report), but merely a check box to signify that payments have started. If no payments have been made and the field is null, the box is not checked. Any suggestions? Cheers. > > I have a number/currency field that I would like to have appear as a check > > box on a report, and am unable to do this in the query or the report. The [quoted text clipped - 6 lines] > of number values; a Check Box value can only contain be -1 or 0. > What are you trying to do? Add a calculated field to your report's record source query: PaymentsStarted: IIf([PaymentsField] Is Null, False, True) Then bind your checkbox control to this field in the report's record source query. SignatureKen Snell <MS ACCESS MVP> > If we have started paying out funds for a certain project, the amount(s) > are [quoted text clipped - 23 lines] >> of number values; a Check Box value can only contain be -1 or 0. >> What are you trying to do? > If we have started paying out funds for a certain project, the amount(s) are > entered into the database. I summed them in a query for other reports that [quoted text clipped - 16 lines] >> of number values; a Check Box value can only contain be -1 or 0. >> What are you trying to do? Add a Check box to the report. Set it's Control source to =[PaidToDate] >0 SignatureFred Please respond only to this newsgroup. I do not reply to personal e-mail Thank you both for your responses. I tried both successfully. > > If we have started paying out funds for a certain project, the amount(s) are > > entered into the database. I summed them in a query for other reports that [quoted text clipped - 20 lines] > Set it's Control source to > =[PaidToDate] >0 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.