Recent content by sichilaba

Just came back from Christmas break. Thank you for the Dcount advice. To every one Have a great year 2015

Hi i got interested to the question you posed. Just wanted to find out if there is another function equivalent to DCOUNT Thank you in advance

Thanks David. At least lam almost getting there....The first record displays the answer correctly but subsequent records displays nothing. How do l fix this?

Hi Find attacment of the CASE Statement on the attached database in Access 2003. Name of the database is Kent. I have typed the code below in the StudentResult text box but it is not working. Please check out the attachment and help Private Sub StudentResult_afterupdate () Dim StudentMark...

Re: CASE Statement in access 2003 on forms REPHRASED Hi Thanks for all the replies. Let me just just rephrase the whole problem. Here is the structure of the Table l created as STUDENTS Field Name Data Type StudentName (Text) StudentID Number (Number) StudentMark (Number StudentResult...

Hi I have created a table known as STUDENTS with the following fields Name (Text) ID number (text) Mark (Number) Result (Text) Then created a bound form based on RESULT TABLE. I need to use CASE Statement on my form in the result text box on form: When a student gets less than 50, its a...