Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
To bperry ( here is some more info)
Still not working it is giving the same " you tried to excute a query that doesnot include the specified expression "ward_code" as an aggregate If u are online and not busy are we able to chat on msn if u have it so we can sort it out, i fell that there is somthing simple wrong... -
How can I calculate the percentage
Hi, I STARTED A THREAD HER BECAUSE I WAS ASKED TO START IT HERE SINCE THIS THE FORUM FOR MS SQL YES I AM USING MS SQL ACCESS IN EXACT I HOPE THIS HAVE HELPED THANKS ALOT- Dado111
- Post #3
- Forum: Microsoft SQL Server: Programming
-
To bperry ( here is some more info)
It is still not working I am getting a message saying that " you tried to excute a query that doesnot include the specified expression "100 * q.RecCnt / ward.bed_count" as an aggregate function" what is ment by q.RecCnt?? thanks for your help -
How can I calculate the percentage
Hi, How can i produce a report that gives for each ward its name, code, and the percentage occupied in the wardof a hospital. knowing that we have the table of "Ward" wich hold a wardCode, wardName, BedCount. And another table for Admission wich has AdmissionID, patient_Id...- Dado111
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
To bperry ( here is some more info)
Hi bperry, Sorry for all this hassel, well yes i am working on Ms Access, and yet (cast) is not working and the message that the program is returning is as follows: Syntax error ( missing operator) in queri expression "CAST ( (Select count(Ward_code) FROM Admission WHERE... -
To bperry ( I have tried ur way but somthing is wrong)
Hi, Thanks for ur solutions i was trying to work on this one below but it is still not working. And to tell u the truth i haven't heard of the "CAST" before maybe it is replacment for some other word so if it is tell me what is it please check the code and tell me what u think Thanks... -
How to calculate percentage in sql
Hi, How can i produce a report that gives for each ward its name, code, and the percentage occupied in the wardof a hospital. knowing that we have the table of "Ward" wich hold a wardCode, wardName, BedCount. And another table for Admission wich has AdmissionID, patient_Id... -
How to get the number of Admissions and lates one??
Hi, We have two tables A person one and Admission one. the person have name, surname,sex,Birthdate, adress, and the admission have Admission_id, Patient_id, Admission_date, Discharge_date. so how can we, list name, surname,latest admission date, and number of times admitted for all women...
