J
jubu
I have an Access 2003 database. The main table get its data from another
system (downloaded) of which some of the number fields come through as text.
Class (refers to number of students in graduating class)
Rank (refers to the students' ranking position in graduating class)
I created a new field in my query for each to "convert" the above to numeric
values:
ClassValue: Val([class])
RankValue: Val([rank])
A third calculated field is created to determine the percentage: Top%:
IIf([ClassValue]=0 And [RankValue]=0,0,[RankValue]/[ClassValue])
When I attempt to put criteria in this Top% field, I get parameters looking
for Top%, ClassValue, and RankValue. I set the Format property for Top% to
Percent, and that eliminated the parameter for Top% but I am still getting
the other two. Any ideas? All suggestions are very much appreciated, as I
continue to learn this program.
system (downloaded) of which some of the number fields come through as text.
Class (refers to number of students in graduating class)
Rank (refers to the students' ranking position in graduating class)
I created a new field in my query for each to "convert" the above to numeric
values:
ClassValue: Val([class])
RankValue: Val([rank])
A third calculated field is created to determine the percentage: Top%:
IIf([ClassValue]=0 And [RankValue]=0,0,[RankValue]/[ClassValue])
When I attempt to put criteria in this Top% field, I get parameters looking
for Top%, ClassValue, and RankValue. I set the Format property for Top% to
Percent, and that eliminated the parameter for Top% but I am still getting
the other two. Any ideas? All suggestions are very much appreciated, as I
continue to learn this program.