Thanks baz for the help, I did paste it into the field so the query table had
bits renamed to Expr1 - Expr4. However exporting this query still didnt show
the 9 figure digits
(000000199 exports to 199)
I will paste the SQL below for you. You will notice i have 4 fields with
your formula in. They are not in order (4 3 1 and 2) However the fields are
"Labour Value" "Material Value" "VAT" "Invoiced Value"
SELECT [Import to Access].[Agreement Number], [Import to Access].[Customer
Surname], [Import to Access].[Address line 1], [Import to Access].[Address
line 2], [Import to Access].[Address line 3], [Import to Access].[Address
line 4], [Import to Access].Postcode, [Import to Access].[Appliance Type],
[Import to Access].[Appliance Make], [Import to Access].[Appliance Model],
[Import to Access].[Invoice Number], [Import to Access].[Completed Date],
[Import to Access].[Breakdown date], Format(Int([Labour
value]*100),"000000000") AS Expr4, Format(Int([Material
Value]*100),"000000000") AS Expr3, Format(Int([VAT]*100),"000000000") AS
Expr1, Format(Int([Invoiced Value]*100),"000000000") AS Expr2, [Import to
Access].[Fault Code], [Import to Access].[Authorisation number], [Import to
Access].[Referral number], [Import to Access].[Repair Agent number], [Import
to Access].[Repair agent branch number], [Import to Access].[Serial number],
[Import to Access].[Part number #1], [Import to Access].[Part description
#1], [Import to Access].[Part number #2], [Import to Access].[Part
description #2], [Import to Access].[Part number #3], [Import to
Access].[Part description #3], [Import to Access].[Part number #4], [Import
to Access].[Part description #4], [Import to Access].[Part number #5],
[Import to Access].[Part description #5], [Import to Access].[Part number
#6], [Import to Access].[Part description #6], [Import to Access].[Rejection
message 1], [Import to Access].[Rejection message 2], [Import to
Access].[Fault as reported by cust], [Import to Access].[Engineer's report]
FROM [Import to Access];