By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,799 Members | 1,365 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,799 IT Pros & Developers. It's quick & easy.

Conditional expression Help...

P: 1
I recently designed report card management system for a college. I'm having a problem with conditional expression. If a student received less than 35 in a particular subject, I wanted "fail" to be printed in the sum or total. I used Dcount function but it counted all the records in the table rather than the report. Count function counted all the records in the report but i could not use the criteria. So some body please help me out.
May 21 '07 #1
Share this Question
Share on Google+
1 Reply

Expert
P: 97
I recently designed report card management system for a college. I'm having a problem with conditional expression. If a student received less than 35 in a particular subject, I wanted "fail" to be printed in the sum or total. I used Dcount function but it counted all the records in the table rather than the report. Count function counted all the records in the report but i could not use the criteria. So some body please help me out.
Try an iif() function:
iif(count([score])<35,"Fail",count([score]))
May 21 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.