Hi guys

I am using access database with Crystal Reports in VS2003
I am working on "Hospital Database"
The fields are -
Name - Date - ConsultingCharge - TotalFees
i.e. Total Fees include fees for medicine issued by hospital


In the report I want to display the Average of  ConsultingCharge and
TotalFees for every record.
i.e.  Name - Date -  ConsultingCharge - TotalFees - Aversge (TotalFees/



ConsultingCharge)
How can we display the average of two fields in database for every
record.


Further in the monthly analysis report I want to display
Month - TotalFees - ConsultingCharge - Average (  ConsultingCharge/
TotalFees )
How to generate report for month from the database with all the dates.
How to display the average of sum of  ConsultingCharge and TotalFees.


Thanks


Amit

@m73g2000cwd.googlegroups.com:

Have you taken a look at formula fields?

Find Files and folders
Problem bei der Installation eines VB.net Programms
HTTP 403.9 - Access Forbidden: Too many users are connected
reversing the Mod operator
Minimizing the Console Window
odbc
CopyMemory(buffer, newBuffer, nBytes)?
Datagridview and arraylist
.net framework 1.1.4322
Looking for VB.NET sample code: radio button list, check boxes