Search results

I have a union query to, both tables have a date formatted as "yyyy mm" to group records by month, I need to combine the PaidTime from tblDuties and PaidTimeAnnualLeave from tblAnnualLeave as AveragePaidTime SELECT Format([DutyDate],"yyyy mm") AS YearMonth, Avg(tblDuties.PaidTime) AS...

How do I go about calculating the % variation based on the previous record E.g. below I would like on 2nd record to show 20% as the increase versus the previous value of 100, on the last record should be 8.33 increase from 120

I have a Union Query which I want to add calculated field SELECT TransactionDate, PensionEmployee, PensionEmployer, TransactionType, FundName, Payments, UnitsTransaction, TOT FROM tblPension UNION SELECT PayslipDate, PensionEmployee, PensionEmployer, Null As Col4, Null As Col5, Null As Col6...

I am looking to develop further my DB project, I am currently tracking payslip data where I have 2 columns with amounts related to payments to a pension scheme, I would like to track transactions of the pension scheme in details and therefore I have additional transaction (e.g. purchase and...

I have a code to add a file link to a txt box and another code to access this file, is all working perfectly and have a minor issue if I decide not to add the link and pres Cancel within the dialog window the errror is The code is: Private Sub CmdAddPayslip_Click() With...

I have the following code to auto fill a form when is loaded as it reads the latest correct values from a table Private Sub Form_Load() SalaryAnnual.DefaultValue = """" & DLookup("SalaryAnnual", "tblSalary") & """" SalaryBasicPay.DefaultValue = """" & DLookup("SalaryBasic", "tblSalary")...

I have the below expression in the Control Source in a form which is working for the one field to sum =DSum("BasicPay","tblPayslip","[payslipDate]>=Forms!FrmPayslip![FYFrom] And [payslipDate]<= Forms!FrmPayslip!PayslipDate") As well as the sum of BasicPay I need to add other fields within the...

I have a generic 'frmStatistics' not linked to a record source, I would like to display results from various queries as a purpose to overlook statistics. One query example is below The query returns a one line result, and I need to use the Avg calculated expressions (AvgOCR, AvgITSOR and...

I need to concatenate "FirstName" and "Surname" from a table with a lookup on a form, I am stuck on how to use concatenate in the code. The code I have under the afterUpdate event for the textbox RefStaffN is: Me.FullName = DLookup("FirstName", "tblEmployee", "StaffN=" & Me!RefStaffN) This is...

I am trying to keep track of duties that have been exchanged for other duties via a tblSwaps and a relative form which will have information about the old duty. The main reference is DutyDateNew within the tblSwaps, which will be a match as same date in the tblDuties The main frmDuties has an...

I am slowly getting to the bottom of my project but have hit a further rock! I am trying to get the total of the field RIDOCR/RIDITSOR/RIDCPCR from the frmRuns into the relative fields on the frmDuties and copy that value in the table so that I can use it for statistic purposes later on. In...

I have a main form with a Add command to add a new record and an edit command. The form has a subform which consequently has a further subform itself with a One to Many relation, all forms and subform are set no additions and no edits in the properties. So I wrote the code to allow additions...

I need to track the length of a duty, some duties go beyond the midnight therefore are recorded as 24:15 for a 00:15 and 25:35 for a 01:35 the next morning as the date is referred to the start of the duty. The StartTime and EndTime fields are currently set as numbers with input mask ‘00:00;0;_’...

I am trying to use the Lookup function to retrieve the description form the table tCodes and apply the description value in the description box in the form tDes with the After Update For example if the users types any number between 100 and 199 in the Code field, the Description is...

I need the correct formula to count the items from a Get items, I need to count those records where Days is greater than 0. I have a variable TotCount with the he expression: if(greater(item()?['Days'], 0), 0, 1) The above code always returns 0, below are a few example of what I need: Days...