Search results

Hi Thanks for your prompt reply So please how do I link this to my sales page? I have drug details table Drug Id Drug name Cost price Batch no etc So you said I should introduce 2 more tables Drugs ID Name 1. Diclofenac Drug Interaction ID interact with 1. 2 The interaction we can have...

Hi Namlian Thanks for your prompt reply. The probable drug interactions are all the drugs. What you mean is after creating a drug interaction table Drug_Interaction Drug_ID -2 Drug_interaction_ID- 1 Drug_Interaction--Ibuprofen, Aspirin Drug Details Drug_ID 2 Drug_Name- diclofenac Drug...

Hi Royce Thanks for your prompt reply Maybe I should make myself clearer In the drug details form, there will be a column for drug interaction and all possible interaction with the drug will be there. For example: Drug_Name- Diclofenac Drug_Interactions- Ibuprofen, Moduretic So at the point of...

Hi everyone Please I need help Please how do I set up my order details page to give an alert if there would be an interaction in the group of drugs entered. Thanks and hope to help from you soon

Thanks sir I have attached the tables

I think I am finding it difficult to locate where to attach my file Any help please Thanks

Thanks so much for your prompt reply Find attached is the relationship screen shot

Good day every one I have a school database but am not sure if it is normalised Can anyone help me proof read. Thanks and hope to hear from you soon

Thanks for the reply and sorry for my late response I don't understand your reply. Do I place what you said in the vba code? Thanks and hope to read from you soon

Thanks for the prompt reply. I have my students table, assignment table, class table , course table and attendance table. I have actually created a report card but don't know how to go about it that the highest score will be included and also the attendant for eact student for the session. For...

Thanks for the prompt reply. I have my students table, assignment table, class table , course table and attendance table. I have actually created a report card but don't know how to go about it that the highest score will be included and also the attendant for eact student for the session. For...

Good day everyone, Please I want to have a report card where I can have attendance embedded in for each students and also the highest score for each class each session. Thanks and hope to hear from you soon

Thanks for your prompt reply I actually chose a correct datatype, decimal Thanks and hope to hear from you soon

Thanks for the prompt reply It is on general number and the decimal column is set to 2. But I have a vba code embedded in the after update of the quantity column I have attached what the vba code looks like It seems I can't find the column to attach so I copy and pasted the code Private Sub...

Hi everyone Please I need your help I have a form order details where u enter the quantity of items you want to purchase and it deducted it from the balance available, it is working fine for whole numbers only, it is not accepting half(0.5) ,(0.25). Any help on how access will be able to accept...

Hello Thanks so much for your help I have made a lot of progress What I am having challenge with now is getting the student with the highest score in class. I mean highest overall score in all the subjects I want to put that highest score on each student report card. Thanks and hope to hear...

Whao Thanks Thanks Thanks so much for the help You are a genius Am really very grateful. It worked perfectly I really appreciate your help.

Yes if that will do the job What I want it to be able to count the number of terms that mary attended for the each subject and divide by the total. The easiest would have been to divide total\3. But I realize that some students may join in late or maybe absent due to one reason So that was why...

Yes a query links the two together Yes this is the query that links the two queries together PARAMETERS N Long; SELECT StudentStatus_Crosstab.StudentName, StudentStatus_Crosstab.CourseTitle, StudentStatus_Crosstab.StudentID, StudentStatus_Crosstab.[First Term], StudentStatus_Crosstab.[Second...

Thanks for your prompt reply SELECT StudentStatus.StudentName, StudentStatus.GradeExam, StudentStatus.GradeAssignment1, StudentStatus.GradeAssignment2, StudentStatus.GradeAssignment3, StudentStatus.TermID, StudentStatus.SchoolYearID, StudentStatus.Total, StudentStatus.CourseTitle...