Search results

  1. P

    Solved Format a number field in form of hh:mm:ss

    Ranman256, Gasman, CJ_London, Minty, Gemma-the-husky Thanks a ton for the inputs and guidance. Have been able to solve it finally. Seems there was data input error as well as instructions error. A decimal was missed out that lead to the KM_Hour being input as 442 KM/hour instead of 4.42 per...
  2. P

    Solved Format a number field in form of hh:mm:ss

    The number 15.35 has to be displayed as 00:15:35 (i.e. 00 hours, 15 minutes, 35 seconds)
  3. P

    Solved Format a number field in form of hh:mm:ss

    Hello, Attached is a MS Access Database "TimeData". Refer "Query_1" in the database. It has a field "Total_Time". This field is a number with decimal created using a builder. This field has to be now displayed in format of hh:mm:ss. Thus a value 15.35 should be formatted / displayed as...
  4. P

    Alphabets / Words instead of Numerical Values for Data Input from Radio Buttons

    Thanks for the reply. This question and the details given are for students of grade 9 and 10 and they do not have coding or VBA etc. So for them they have to use the basic functionality of MS Access and do this conversion from Values to a string. Is this possible? Thanks again.
  5. P

    Alphabets / Words instead of Numerical Values for Data Input from Radio Buttons

    Hi Re : MS Access 2013 Form - Radio Buttons - Gender Entry - M or F I am not an expert with MS Access and hence posting a very basic question. We are connected with education field and this doubt is worrying our students. Unfortunately the school ICT teachers have neither attended to the...
  6. P

    Validation Rules - Logic

    Hi Forum Members We are engaged in teaching ICT to students (IGCSE). Database management is a important subject for them. We teach this subject using MS Access Application. The new generation of students ask a lot of logical questions and if these questions are left un-answered, they feel a...
  7. P

    Doubts re 'Data Type' for certain fields

    Dear Minty Dear Ridders Dear Galaxiom Dear Sonic 8 Dear Pat Hartman Thank you very much for your time and efforts to throw some light on the doubts. Have been able to - thus with your help - resolve the doubts of the students. Regards / Pinesh
  8. P

    Doubts re 'Data Type' for certain fields

    Agree to your answer and views. Thank you so very much
  9. P

    Doubts re 'Data Type' for certain fields

    Hi I am from India and engaged in teaching ICT to students who appear for IGCSE exam - from India. MS Access (Database Management) is a subject in ICT. I have a very simple - base level question / doubt. Refer to the attachment - IGCSE question paper - Question 9B. The question is what is...
  10. P

    MS Access tutoring to students

    Hi I am from India and engaged in teaching ICT as a subject to students for their IGCSE examinations. I have basic knowledge of MS Access and... many questions. Seeking support from forum members re doubts about MS Access with respect to academics. Thanks Regards / Pinesh
Back
Top Bottom