Comments by chandresh singh 2 (Top 2 by date)

chandresh singh 2 14-Jul-13 4:14am View

I am making a library management project and i am facing problems in fine calculation part. I have Date_Of_Issue and Date_Of_Submission fields (both set to Date/Time datatype) in a table named Book_Details(the database i am using is sql server 2008).

All i want to do is a query which will calculate the difference of days between the Date_Of_Submission and Date_Of_Issue.

If the difference of days is more than 5,then a fine will be charged by the student on a basis of $5 per day i.e; if the difference of days between the Date_Of_Submission and Date_Of_Issue is 7 days,then a fine of $10 will be charged ny the student.

How to do this?

Please please help

chandresh singh 2 14-Jul-13 4:12am View

Deleted

I am making a library management project and i am facing problems in fine calculation part. I have Date_Of_Issue and Date_Of_Submission fields (both set to Date/Time datatype) in a table named Book_Details(the database i am using is MS-Access 2003).

All i want to do is a query which will calculate the difference of days between the Date_Of_Submission and Date_Of_Issue.

If the difference of days is more than 5,then a fine will be charged by the student on a basis of $5 per day i.e; if the difference of days between the Date_Of_Submission and Date_Of_Issue is 7 days,then a fine of $10 will be charged ny the student.

How to do this?

Please please help