Hi,
Thanks a lot for your reply.
The Qty field in Table 2 is for the Hours and the Amount field is for the cost. The Hours will be multiplied with the Rate and the output will be the Cost (Hours x Rate = Amount (Cost).
I only want the rates to be overwritten in Table - 2. Once the rate is...
Hi, sir,oleronesoftware
I am very glad hearing your reply. Following are my suggestions for the observations.
1) In table one is it necessary to create a field for number of days because my observation was the number of days can be calculated from Table two by counting the Date field. If...
Dear Sir,oleronesoftware
I appreciate your quick response, I have gone through your altered Data Base and it serves my purpose manually. The main problem with the same is its a bit time consuming since we are having so many plants working in our site, individual entries and checking of each...
Dear all
Please find the attachment andkindly help me with the calculation commands mentioned. I need to adopt these calculations in the DBMS.
Since I am new to the DBMS, I am not familier with the advanced calculation commands. So, I kindly request your valuable guidance and suggestions to...