currency field to appear in report as check box/true false

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
Click to expand...

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?
 
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.
 
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.
 
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.
Click to expand...


Add a Check box to the report.
Set it's Control source to
=[PaidToDate] >0
 
Thank you both for your responses. I tried both successfully.

fredg said:
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.
Click to expand...


Add a Check box to the report.
Set it's Control source to
=[PaidToDate] >0
Click to expand...
 
Back
Top