Hi All, I want to take result of Rate * Hours. The rate and hours stored in two tables. How can I perform this calculation? Thank you
If you had say a
Rate Table with fields like
and a Employee Table with Fields
and a Employee Hours Table with fields
Each record in the Employee Hours table would be an entry for any Employee and pick up the rate from Rate Table.
Is this the sort of thing you are after? Of course your requirements could be different ...
without seeing your relationship diagram and knowing where the result will go it's hard to say.
Thank you so much for your answers, that what exactly i wanted.
Retrieving data ...