Results 1 to 11 of 11

how to make query results in table 10 characters long?

Threaded View

jgomez how to make query results in... 08-12-2011, 11:21 AM
jeffreybrown Re: how to make query results... 08-12-2011, 11:26 AM
jgomez Re: how to make query results... 08-12-2011, 11:38 AM
jeffreybrown Re: how to make query results... 08-12-2011, 11:52 AM
jgomez Re: how to make query results... 08-12-2011, 11:56 AM
jgomez Re: how to make query results... 08-12-2011, 11:58 AM
jeffreybrown Re: how to make query results... 08-12-2011, 12:00 PM
jgomez Re: how to make query results... 08-12-2011, 12:02 PM
jeffreybrown Re: how to make query results... 08-12-2011, 12:11 PM
jgomez Re: how to make query results... 08-12-2011, 12:18 PM
jgomez Re: how to make query results... 08-19-2011, 03:00 PM
  1. #1
    Valued Forum Contributor
    Join Date
    12-22-2010
    Location
    Texas
    MS-Off Ver
    Excel 2003 & Excel/Access 2007
    Posts
    438

    how to make query results in table 10 characters long?

    Hi there got a problem don't know if its even possible to solve.

    I'm running a query that exports into a table in access. Two of the fields give me results made of numbers ex.

    field 1 field 2
    123 25
    156455 1158
    I would like to somehow make those results into 10 digits long

    field 1 field 2
    0000000123 0000000025
    0000156455 0000001158

    any ideas?
    Last edited by jgomez; 08-19-2011 at 03:00 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1