Help! About function

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

Guest

Dear friends,
I want once again your help. For two subjects:
1) I want if i have for example the number 4,7, to take 4 and the 7. What
functions i must use?
2) I have which contains this fields: Stud_ID(Long Integer ), Lesson(Text)
and Exam(Double), and i want for each lesson to have the number of students
who take in exams over 5, and the percent ( %) of them by lesson. How i
create that?
Thanks for your time. I look forward for your reply :)
 
Dear friends,
I want once again your help. For two subjects:
1) I want if i have for example the number 4,7, to take 4 and the 7. What
functions i must use?
Click to expand...

If this is in European format, with , as the decimal separator, you
can get the integer portion of the number (4) with the expression

Fix([fieldname])

and the fractional portion .7 with

[Fieldname] - Fix([fieldname])
2) I have which contains this fields: Stud_ID(Long Integer ), Lesson(Text)
and Exam(Double), and i want for each lesson to have the number of students
who take in exams over 5, and the percent ( %) of them by lesson. How i
create that?
Click to expand...

With a Totals query; but not knowing what you mean by "take in over 5"
I'm not at all certain how to frame the query.
Thanks for your time. I look forward for your reply :)
Click to expand...

If you're more comfortable posting in German please do so, or if you
prefer, in the German language newsgroup microsoft.public.de.access.

John W. Vinson[MVP]
 
Back
Top