Search results

Hi Everyone, I'm wanting some advice on how to optimise a query expression. I have the below query that determines the employees rate, based on which bracket their total income falls into. I'm concerned that I have not writting this expression in the most efficient manner and would...

Hi Everyone, I have an existing access database that I use for a number of purposes and I need some advice when using Lookups in a table. In my database, I have a table called RTBL_Paycodes. This lists all the payment codes from our payroll database (screen sample attached). A field in...

Thanks Paul. As Im not an expert with access, I'm not exactly sure how to use this code.

Hi Everyone, I have a report called LRPT_PaymentProcessing_Std. This report has a number of sub reports within it, for example, LRPT_PaymentProcessing_Detail_Std_HoursLeave. The LRPT_PaymentProcessing_Detail_Std_HoursLeave sub report contains a total, AccessTotalsPP_Det_AValue. In my...

Hi Everyone, I have a database where my team will enter manual payment calculations into. Once entered, they will run and print the report for actual payment. The report I have groups by payment type (see attached image of paymetn types) and then sub totals by group. I need to somehow...

Thank you, awesome. Works great.

Hi Everyone, I have a database that tracks workorders and then the associated invoices that result froma workorder. The process is that the user creates a workorder and when an invoice related to the workorder comes in, they register the invoice and select the workorder it belongs to. I...

Hi All, I have a database where we store payroll values. Against each payroll, we record the PayrollPaymentDate. This is the date in which the payroll was paid to employees. I need to generate a due date for our taxes. This is always the first thursday the week after the PayrollPaymentDate...

Hi Everyone, I have a database used to calculate the payout figure to employees when they leave our company. In this database I have the Hire Date and Separation Date. In some cases we have to pay out Long Service leave and we need to break this down into three buckets. 1. Pre...

Hi Everyone, I have created a form in Access 2010 that opens in view only mode. I do this as I do not want data being changed in error. There are times when the user may need to edit some data on the form. Can anyone suggest a way to place an "Edit" button on the form that allows the user...