Paye - Calculate At Runtime Or Store The Deduction?
Since this is a calculated figure I obviously doesn't store it in any table but call GetTax(TotalEarning) at runtime when creating payslips, viewing payrollrecords or printing reports.
However, the tax rules in my country was changed recently which requires that I modify the tax brackets, salary cut off and tax rates in my tblPayrollTaxSettings. previous pay runs will no longer reflect the old deductions but with deductions using the new tax rates.
Now this got me thinking.should I have stored the calculated PAYE deductions in thetblPayrollDeductions table along with other salary deductions and with these new tax I would still have had my payment history reflecting what each employee was paid previously?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I my country the tax rate for PAYE is applied on a graduated scale as shown below:
- First $30,000 at 5%
- Next $30,000 at 10%
- Next $50,000 at 15%
- Next $50,000 at 20%
- Above $160,000 at 25%
So what I want is for my textbox "txtPAYE to evaluate "txtEarning" based on those garduated scale with an IF statement. I don't know how possible that is. It would have been very strait forward for me if it was for a tax that has a constant rate
payroll: (Store, lastName, PayFreq, SSN (PK), HireDate, EffectiveDate, TermDate, DeductionCode, Deduction, NAD CHAR) AND hrconnection: (Store, lastName, CoTime, Plan, Dependants, HireDate, EffectiveDate, TermDate, SSN (PK), Deduction).
I want to find the records based on SSN that are in the payroll table and are not in the hrconnection tables and then find the record based on SSN that are in the hrconnection but are not in the paypal table.
I receive, after the fact, sales information which I import, add some extra information, and produce some meaningful reports. There is onearea that I am doing circles on and hence my question.
This represent the quantity on hand by product group by sales day. The value to calculate is the quantity on hand at the end of the day which will then be used as the opening quantity for tomorrow.
Option 1: Should I store this end of day quantity and then run a query, or a dlookup, to find yesterdays end of day quantity to calculate todays end of day quantity?
Option 2: Should I create some starting amount and then run a query to calculate yesterdays end of day quantity?
The basic structure for the stock table is:
Does anyone know how to calculate the average of a field in onetable and store it in another?
I have the SQL that accurately calculates the average of the field, I just can't get it to store in the other table's field.
I would like to be able to keep a running total of how much the employee has contributed each payroll based on his deduction. The payroll is bi-weekly so there are 26 periods in the year.
the payroll dedution amount is a calculated amount based on the annual contrbutuion/26
I was hoping that I could have a field on my report that would allow me to key in the week number and it would calculate the Sum of his dedcutions but I can not find a way for this to work.
Will this work or is there a better way to go about getting this information onto my report.
I have a financial database that has many Tables, each table has many fields primarily holding currency data.
I understand from research that it is incorrect to calculate and store a ‘result’ in a Table, so, I’ve created a Query in order to calculate and store my result which is the TOTAL of all the currency fields in a given record. From my research, I believe the best way of doing that is to add an extra currency field to my Table so the field name is there for when I build my query (still holding with the idea you shouldn’t store a result in the Table itself).
I’ve entered the following formula into the Query by using the ZOOM feature (it is entered into the filed column [WkCashInUnTOT]. The syntax looks like this:
So, to simplify, here is the above broken down:
I have Table1 and Table2 and Field1 and Field2.
Table1 --> Field1
Table2 --> Field2
I want the Field2 = Sum of Field1. I've read everywhere it's better to just calculate the number rather than store it in a table, but I don't need the number to be recalculated since it will most likely never change
I have imported an excel file with the cost price and the trade and cash price already calculated. In my form I have made formulas to calculate the trade and cash price if the cost price needs to be changed, but I do not know how to save these values back to the table (update the trade and cash price when the cost price has changed).
I know a bit about Access, but nothing about macros and VBA.
Would it make sense to have a textbox that would populate a "Workdays" field in my reservation table, and then use that field in a query to calculate the reservation cost? Or do I even need to store the workdays value? Maybe on the after update event for Dateout and DateIn fields on my form?
1) If I use Runtime, does it eliminate the need to hide the navigation pane, menus and ribbons?
2) Does it create an executable file that can be used on any computer, regardless of whether Access is installed or not?
3) Does Runtime need to be previously installed on the Users' computers?
4) Is a Runtime file a smaller footprint than an ACCDE?
5) Are there disadvantages to distributing a Runtime file instead of an ACCDE?
The sources I've found so far on Runtime are a bit confusing.