Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    1

    Question Unanswered: renaming fields in queries with VB

    Does anyone know how to rename a field in a query using VB?

    For example, I want to change the field P1 Net from the Net Table to P2 Net from the Net table.

    Thanks.

  2. #2
    Join Date
    Oct 2001
    Location
    Chicago
    Posts
    440
    Select [P1 Net] as [P2 Net] From [Net Table]

    Is that what you're after or did you want to change the table name using SQL in VB?

    Matt

Posting Permissions

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