E9-Tech's latest activity
-
EE9-Tech replied to the thread Solved Union Query Average Grouped.This code works! Thanks
-
Enot tested: SELECT YearMonth, Avg(PaidTime) AS AveragePaidTime, Avg(SpreadTime) AS AverageSpreadTime...
-
EFirst SELECT in UNION defines field names. The AS aliases in the second SELECT are not needed and won't even show. In other words can do...
-
EIt will however remove duplicates. Suggest use UNION ALL to prevent this
-
EA UNION query does not merge records, it combines the individual records from each source into one common form/presentation. Hence you...
-
EI 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...
-
-
E@E9-Tech In a query you can use the format properties on a column to set the formatting. There is really no need to round a shown...
-
ESee here on Allen Browne's site for a method to get a value in the previous row. First, get rid of the Variance column in your table -...
-
EIDDateFromTotValuePreviousValueDifferencePercentChange 112/8/2024100 22/3/20251201002020.00% 33/1/2025130120108.33% Query1...
-
EHow 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...
-
-
EE9-Tech replied to the thread Solved Union Query with Calculations.I receive email notifications for any answer I get, the screenshot shows the email I received with "" As TOT, Then if I go to the thread...
-
ESomething like this: SELECT TransactionDate, PensionEmployee, PensionEmployer, TransactionType, FundName, Payments, UnitsTransaction...
-
EE9-Tech replied to the thread Solved Union Query with Calculations.Thanks for the solution. Something really weird, the email notification I received came with a difference code as per screenshot below...
-
-
EE9-Tech replied to the thread Solved Union Query with Calculations.Still confused!!!! I changed the code to SELECT TransactionDate, PensionEmployee, PensionEmployer, TransactionType, FundName...
-
-
EI have a Union Query which I want to add calculated field SELECT TransactionDate, PensionEmployee, PensionEmployer, TransactionType...
-
