Hello all,
I have a query that is basically exporting a count of items to Excel. I was wondering if it was possible to export to excel which would include a formula in a cell. So that the user of the report could enter a value into the excel and automatically do a simple calculation.
My query is as follows:
SELECT LV_UNQ.OrderCode, Count(LV_UNQ.OrderCode) AS CountOfOrderCode, 0 AS HoursWorked, "=C2/B2" AS Calculation
FROM LV_UNQ
WHERE (((LV_UNQ.FirstOfResultDate)>=Date()-1))
GROUP BY LV_UNQ.OrderCode, 0, "=C2/B2"
HAVING (((LV_UNQ.OrderCode)="Test"));
However, when it is exported to Excel, the formula column is not "recognized" as a formula.
Below is what the Excel export looks like:
OrderCode Count HoursWorked Calculation Test 594 0 =C2/B2
I'm hoping the end user can enter a value into HoursWorked and that the Calculation would auatomatically calculate.
I'm open to any ideas. Thanks