Hello.
Is it possible to be able to display the Total in a ajax popup box?
I have this code
SELECT
Normal_Hours,
Time_Half_Hours,
Double_Time,
Expenses,
R176,
IFNULL((select Time_Half_Hours*1.5), 0) AS Time_Half,
IFNULL((select Double_Time*2), 0) AS Time_Double,
(select Normal_Hours+Time_Half+Time_Double) AS Total,
Job_No
FROM report
If there are three entries in the table, it will display the three entries on the Preview details in a popup, but it wont show the total. In Fields Order I click on the Total and select total from the popup, It will display the Total amunt whemn you open the record, but not in the POPUP?
Cheers
Paul.