Search results for query: *

Hello, Report is to show data for each week based on a date range prompt I have this formula but it errors saying the {?DateRange} prompt I get an error "A date is required here." with the {?DateRange} highlighted If DataPart("ww", ({TransactionDate}) = DatePart("ww",{?DateRange}) then...

Hello, I am trying to figure how to find dates in TransactionDate that falls into the PeriodEndingDate So company does not use the calendar year for their fiscal year. TransactionDate contains dates when the invoice transaction posted. Each FiscalPeriod for each year doesn't necessary end on...

Hello, I'm trying to figure out how to limit the number of records based on the quantity field My attempt: INSERT INTO dbo_SO_InvoiceTierDistribution ( InvoiceNo, LineKey, LotSerialNo, TierType, ItemCode, WarehouseCode, QuantityShipped ) SELECT dbo_SO_InvoiceDetail.InvoiceNo...

Not sure if I'm asking that correctly? There are several fields for a section and the user would like to see the fields combined when they are checked and display the field name(s). So I started this but it's not fully working If {RA_ReceiptsHeader.UDF_COMPLETE_SET_OF_ATTACHMENT} = "Y" then...

I can't figure out how to display records with $0 but with YTD totals when there's no data in the selected quarter Here's the query The form has 3 for the Quarter and 2020 for the Year Since the end goal is to report on all companies and employees of the reporting year on a quarterly basis...

I can't figure out how to display the YTD totals with the Mth1, Mth2, Mth3 to display the previous quarter totals This is what I have so far SELECT tblEmployees.CompanyCode, tblEmployees.DepartmentNo, tblEmployees.EmployeeNo, tblEmployees.LastName, tblEmployees.FirstName...

Hello, I can't seem to figure out how to get First month of the previous quarter total Second and Third I have the following but the totals aren't correct UNLESS it's ran in the 1st month of the current quarter for the previous quarter data. here are the snippets...

Need help on how to determine the unique number of employees in each month of the quarter by the 12th of the month in the previous quarter. ** How many employees worked by the 12th of each month in the previous quarter. So tx number of employees each month by the 12th of the month of the...

Hello, I have this issue when trying to multiply the Quantity Shipped to the Unit Price to get Extended Total. Which is, it turns it into a positive total since it's multiplying negative by negative. I can't think of how to change it so it results in the correct negative / positive total?

Hello, So I'm close but can't figure out how to go about only showing the previous quarter sum and then to handle the last quarter to display when ran in the 1st quarter the following year. This is what I have so far SELECT PR_Employee.EmployeeKey, PR_Employee.DepartmentNo...

Hello, I can't seem to get this right. If {PR_EmployeeTaxHistory.CalendarMonth} = "01" and ToNumber({PR_EmployeeTaxHistory.CalendarYear}) = Year(CurrentDate()) then ToNumber({PR_EmployeeTaxHistory.CalendarYear}) = Year(CurrentDate())-1 else ToNumber({PR_EmployeeTaxHistory.CalendarYear}) =...

Trying to set a "page break" on Group Footer #4, however the DepartmentRecap info on the Group Footer with the Check Amount are showing on the employee page and then the details on the next page. I have it set on New Page After the formula NOT OnLastRecord Tried it just checking the New Page...

There's a field with information in it that's combined rather than separated out. And unfortunately it varies Example of the variations [code] 12/1/2017 P11345-PP 12/6/2017 12/15/2017 B124536-CM 12/31/2017 2/28/2018 A919777-IN 3/30/2018 3/7/2018 A959264-IN 4/6/2018 10/15/2018 C234364-DM...

Hello, I can't figure out why, but the script to refresh, save then export and save as a .xlsx from the .xlsm with multiple worksheets keeps freezing, I believe on processing the Export function. This hasn't happened before so I am not sure why it started. I compared the script with other...

There's a field with 6 characters in which the last 4 are the month and date (mmdd) Looks like this for instance, today, the batch number is 000809 I need to convert that into a date so I've attempt the following: Format(Right([Batch Number], 4), "mm/dd/" & "2018" in order to achieve 08/09/2018...

Please see image Need to have the QOO, QPO and the Months summed to calculate against the item QOH as a single row

Hello, This is frustrating Situation: 1) Linked to SQL Tables 2) One table, AR_OpenInvoice will not work with the Update Query or Pass-through Query 3) AR_OpenInvoice has PrimaryKeys 4) All other tables in the SQL db update using the Update Query in MS Access 5) I don't believe it's a...

I am unable to do a Sum on the following formula Q1Taxable: If Sum ({@Q1}, {@Name}) > {@UILimit} then {@UILimit} else Sum ({@Q1}, {@Name}) Where Q1: If {PR_EmployeeTaxHistory.CalendarMonth} IN (["01", "02", "03"]) then {PR_EmployeeTaxHistory.GrossWages} else 0 The Q1Taxable is on the...

For some reason this stopped working recently. Initially it appeared to be an updated for Office a few weeks ago. IT reinstalled and that seemed to have fixed it though running the Task it didn't seem to run, however the scheduled task ran next day. In the past week it has stopped and nothing...

Hello, There's this report and on Suppress Freight and InvTotal (so not to repeat when there are multiples lines on an invoice) if OnLastRecord = False then Next({AR_InvoiceHistoryDetail.DetailSeqNo}) <> '000000' Else False How do I modify it to also handle if the 1st record doesn't have...