Search results

Thanks...Please guide me how can i perform the query that you talked about in your first comment?

Bill information is the information regarding a patient's medical visit to a hospital including medicine charges , treatment charges,doctor fee etc the Receipt table is for that purpose .Tell me if i am doing something wrong?

You mean that we do not need to store the biling information of a patient?

I am making a basic hospital management system in Access 2013.I have two tables named "Bed" and "Receipt". Bed(BedID,AssignedDate,PatientID,DischargeDate,BedCharges) Reciept(ReceiptID,PatientID,BedCharges) I want to calculate "BedCharges" by calculating the number of days using...