:banghead:I have a Contract Table:
Order ID
Client Name
Unit Daily Rate in GBP
No of Unit
Contract Start Date
Contract End Date
Requirement: To run a billing run every Month End. e.g. I will be running Feb-2014 billing report on 03-March-2014. This mean every month Billing End Date is different.
What is the best way of set up this query? - Please HELP!!!
Order ID
Client Name
Unit Daily Rate in GBP
No of Unit
Contract Start Date
Contract End Date
Requirement: To run a billing run every Month End. e.g. I will be running Feb-2014 billing report on 03-March-2014. This mean every month Billing End Date is different.
What is the best way of set up this query? - Please HELP!!!