M
Mota
Hello;
In a medical system we have a table to store our prescriptions, named
prescriptionsTBL.This table has some fields such as [PID] as its primary
key,[DOP] or DateOfPrescription,[SumPrice] and so on.In this table,each
prescription get a unique PID and has a record for itself.So at the month
end,number of records shows Count of all Prescriptions we had at this
month.Now what i want is to know Average of daily Prescription Count thru
this month.In other word,averagely how many prescription we have dispensed
in a day of this month?So, the query returns just one number,mostly a
Single.Can anyone please help me to make a SQL statement for this query?
Thank you so much for ur help.
In a medical system we have a table to store our prescriptions, named
prescriptionsTBL.This table has some fields such as [PID] as its primary
key,[DOP] or DateOfPrescription,[SumPrice] and so on.In this table,each
prescription get a unique PID and has a record for itself.So at the month
end,number of records shows Count of all Prescriptions we had at this
month.Now what i want is to know Average of daily Prescription Count thru
this month.In other word,averagely how many prescription we have dispensed
in a day of this month?So, the query returns just one number,mostly a
Single.Can anyone please help me to make a SQL statement for this query?
Thank you so much for ur help.