The way numbers are stored

  • Thread starter Thread starter Guest
  • Start date Start date
Baz said:
Ernest Lai said:
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];
Click to expand...

That looks fine to me Ernest. I repeat my previous suggestion: are you
using Excel to examine the exported data? If so, don't, try looking at it
in Notepad.
Click to expand...

______________________________________________________

No Baz :( It saves as a text file and when i double click it automatically
opens with notepad. I am suspicious now, maybe the company messed up and its
not actually a text file they want. Although getting a test file or any
answers from them is like squeezing water out of a rock.

I will let you know how it goes Baz, as the query works. I exported as an
excel file and the 00000's shows, just not with txt files.

Thanks very much for the help Baz, much appreciated

Ernest
 
Back
Top