Error subtracting

[Derrick T. Davidson]

I have a query that deducts a number from another number and gives me the difference:
Actual Hours: [tblClientBookingForm]![ActualReturnTime]-[tblClientBookingForm]![ActualPickTime]
i.e. 19.09 - 9.00 result 10.09

I then do another query that "should" deduct a number from the result i.e. 10.09 - 8.00 result "should" be 2.09
Expr16: [Actual Hours]-[HoursBooked]



I am using number format not date format in all the entries, but when I execute I get the error message below:

"Syntax error (missing operator) in query expression 'Actual Hours - [tblClientBookingForm].[HoursBooked]

What am I doing wrong ????

[stmoong]

Either use another query to form the final query. Your first query will have the [Actual Hours] computed. The final query will be able to make use of the [Actual Hours]

Otherwise, you can just use a long formula like so:
[tblClientBookingForm]![ActualReturnTime]-[tblClientBookingForm]![ActualPickTime]-[tblClientBookingForm].[HoursBooked]

[June7]

Why 'another' query if all the fields are in the same table?

SELECT [ActualReturnTime]-[ActualPickTime] AS ActualHours, [ActualHours]-[HoursBooked] AS HrsDiff;

[Derrick T. Davidson]

Please do not be angry I am a novice here, where do I enter the above as when I try to put into an expression I get an error message "Invalid syntax you may have entered an operand without an operator"

[June7]

That is the statement for a query as shown in the SQL View window of query builder - but I forgot to finish it.

SELECT [ActualReturnTime]-[ActualPickTime] AS ActualHours, [ActualHours]-[HoursBooked] AS HrsDiff FROM tblClientBookingForm;

Access Help has guidelines on using the query builder and constructing calculated fields in query.