Restrict Display in an Access 2007 Query

#1

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

#2

bobdydd schrieb:

Quote:

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

--
regards, Bernd
---
Access goes Subversion - http://oasis.dev2dev.de

#3

On 25 June, 13:24, Bernd Gilles <newsgro... (AT) gilles-family (DOT) de> wrote:

Quote:

bobdydd schrieb:

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
Hi

Thanks I will try that

Best Regards

Quote:

2003415699520522072543

Displays as

100464949225
200343666634
200341569952

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

--
regards, Bernd
---
Access goes Subversion -http://oasis.dev2dev.de

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Restrict Display in an Access 2007 Query

comp.databases.ms-access comp.databases.ms-access

Restrict Display in an Access 2007 Query - 06-25-2010 , 06:13 AM

Re: Restrict Display in an Access 2007 Query - 06-25-2010 , 07:24 AM

Re: Restrict Display in an Access 2007 Query - 06-25-2010 , 09:45 AM