423,818 Members | 2,266 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,818 IT Pros & Developers. It's quick & easy.

HELP: Reports: changing values of YES/NO fields

P: n/a
I've built a CROSSTAB query that will list attendance for classes.
Since the ATTENDANCE table tracks if someone was ABSENT with a yes/no
field, the results of the crosstab show "-1" if checked.

I create a report by building the labels and set the control source of
each textbox. It's working well and the correct data is showing, but
here's the prob:

1. If someone was absent (ATTENDANCE.ABSENT = "NO" [field type:
yes/no]) then the value in the box is -1

2. There is a total of all values, so I can keep track of how many
absences there are for a particular student. While it sums it right,
it's totaling negative values.

What I'd like to do is either replace a -1 with a checkbox who's value
is checked, as well as, really, multiply the value of the total by -1
to get a positive value. However, when I'm coding in VB, the auto
dropdown box shows no options for values of textboxes or checkboxes.

Any thoughts?

Thanks!

Aug 3 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
UPDATE:

Ok... Part 2 is done... I used the ABS() function in the crosstab to
make the negative sums positive.

Now, all I need to do if figure out the checkbox so the report isn't
filled with a bunch of 0's and -1's.

Thanks.
mm*************@gmail.com wrote:
I've built a CROSSTAB query that will list attendance for classes.
Since the ATTENDANCE table tracks if someone was ABSENT with a yes/no
field, the results of the crosstab show "-1" if checked.

I create a report by building the labels and set the control source of
each textbox. It's working well and the correct data is showing, but
here's the prob:

1. If someone was absent (ATTENDANCE.ABSENT = "NO" [field type:
yes/no]) then the value in the box is -1

2. There is a total of all values, so I can keep track of how many
absences there are for a particular student. While it sums it right,
it's totaling negative values.

What I'd like to do is either replace a -1 with a checkbox who's value
is checked, as well as, really, multiply the value of the total by -1
to get a positive value. However, when I'm coding in VB, the auto
dropdown box shows no options for values of textboxes or checkboxes.

Any thoughts?

Thanks!
Aug 3 '06 #2

P: n/a
Aaaaannnd done!

Both problems solved.
mm*************@gmail.com wrote:
UPDATE:

Ok... Part 2 is done... I used the ABS() function in the crosstab to
make the negative sums positive.

Now, all I need to do if figure out the checkbox so the report isn't
filled with a bunch of 0's and -1's.

Thanks.
mm*************@gmail.com wrote:
I've built a CROSSTAB query that will list attendance for classes.
Since the ATTENDANCE table tracks if someone was ABSENT with a yes/no
field, the results of the crosstab show "-1" if checked.

I create a report by building the labels and set the control source of
each textbox. It's working well and the correct data is showing, but
here's the prob:

1. If someone was absent (ATTENDANCE.ABSENT = "NO" [field type:
yes/no]) then the value in the box is -1

2. There is a total of all values, so I can keep track of how many
absences there are for a particular student. While it sums it right,
it's totaling negative values.

What I'd like to do is either replace a -1 with a checkbox who's value
is checked, as well as, really, multiply the value of the total by -1
to get a positive value. However, when I'm coding in VB, the auto
dropdown box shows no options for values of textboxes or checkboxes.

Any thoughts?

Thanks!
Aug 4 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.