table. The table includes 10 integer fields which, when summed, are
considered the overall rank for that record. I found I was unable to
add this calculated overall rank field to the table, so instead, I
added it to the form as an unbound text box with a label of "Overall
Rank".
This does work, in the sense that for each record it does dislay on the
form the sum of the 10 integer fields in that record. The problem is
that I want to add a command button that will toggle between sorting
the form based on the combination of "Overall Rank" and the
bound "Status" field and sorting it based a different bound field -
"ID". But I cannot seem to use the "Overall Rank" data in any sort
whatsoever. And I'm guessing it's because it's unbound. How do I get
around this problem?
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
