Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SimonSwann

    Using 'AS' in select statement Error 247

    I need to rename a column when using a select statment. When I use 'as' in the statment I get an error **Unable to understand after -"DECLARE".(247) **Invalid Statement.(254) I have tried putting the name in single quotes and double quotes. I am trying this in MS Query using...
  2. SimonSwann

    Email Address AND Title for Additional Contacts

    Sorry Michael althought the reply you sent did not answer my question I found a previous submission of yours that did. Thank you
  3. SimonSwann

    Email Address AND Title for Additional Contacts

    I want a query to get email addresses and titles for the additional contacts held in CONTSUPP. I cannot find a way of associating the two separate lines that carry these pieces of information Thank you

Part and Inventory Search

Back
Top