Results 1 to 2 of 2
  1. #1
    cypress is offline Novice
    Windows 98/ME Access 2002
    Join Date
    Sep 2010
    Posts
    1

    Exporting only specific data


    We have built a query that outputs several columns of information. This information gets exported into specific Excel spreadsheets according a code the person exporting it enters. In one of the columns we only want to export a few of the text in the column. For example, the text in a specific column would say "1 2 3 4 5". In our exported spreadsheet, we only need to show the numbers "3 5". How do you write it in the export query or in the VB code to only show the "3 5" when exporting?

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    use some text functions to get the portion which you need. e.g. mid, left, right etc.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. get a specific data in a string
    By dada in forum Programming
    Replies: 2
    Last Post: 09-21-2010, 01:20 AM
  2. Code to pull in data from a specific record
    By jdunn36 in forum Access
    Replies: 1
    Last Post: 09-20-2010, 11:54 AM
  3. Replies: 7
    Last Post: 12-11-2009, 01:44 AM
  4. find specific data
    By hoachen in forum Queries
    Replies: 3
    Last Post: 08-19-2009, 08:54 AM
  5. Automatic Data Entry on a Specific Date
    By alanbrai in forum Programming
    Replies: 2
    Last Post: 11-14-2007, 05:15 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums