Restrict Display in an Access 2007 Query

[bobdydd]

Hi

I have a field in a table called tblTransaction in
which there is a field called "ListingEbayNumber"

I have created a simple query that just has the single
field "ListingEbayNumber" and Criteria = "Is Not Null"

The field is collecting the "ListingEbayNumber" as it
"really" is...a 22 digit number

I would like to be able to see just the first 12 digits
of the number and export it as a .csv file

1004649492250624085656
2003436666340521154757
2003415699520522072543

Displays as

100464949225
200343666634
200341569952

Thanks in advance

 

[Bernd Gilles]

Hi

I have a field in a table called tblTransaction in
which there is a field called "ListingEbayNumber"

I have created a simple query that just has the single
field "ListingEbayNumber" and Criteria = "Is Not Null"

The field is collecting the "ListingEbayNumber" as it
"really" is...a 22 digit number

I would like to be able to see just the first 12 digits
of the number and export it as a .csv file

1004649492250624085656
2003436666340521154757
2003415699520522072543

Displays as

100464949225
200343666634
200341569952

SELECT Left$([ListingEbayNumber],12) AS EbayNumber FROM MyTable

 

[bobdydd]

bobdydd schrieb:

Hi

Thanks I will try that

Best Regards

2003415699520522072543

Displays as

100464949225
200343666634
200341569952

SELECT Left$([ListingEbayNumber],12) AS EbayNumber FROM MyTable