Uncategorized

MS Access SQL Query

Write SQL queries based on the database in excel.
1. Provide billing details (Invoice number, visitID, date, item name and id, amount) for those invoices which are not billed for ‘Lab work’, ‘Pharmacy’ and ‘Office visit’ and whose payment is not made. Also calculate the 7 % interest on the billed amount and display both interest amount as Late Penalty and the new billed amount.

Leave a Reply

Your email address will not be published. Required fields are marked *