MS Query

[Peter Thomas]

A simple piece of SQL that works in Access does not work in MS Quer
(EXCEL)

ACESS:

SELECT 'http://xxxxxx/im/WebClient?IssueID='&ciuser_Issues.ID
FROM ciuser_Issues;

ACESS RESULT
SQL above returns a result that catenates my text with the issues.id.

http://xxxxxx/im/WebClient?IssueID=1

In MS Query I need to use :

SELEC
'http://xxxxxx:9001/im/WebClient?IssueID='+STR(ciuser_Issues.ID)
FROM ciuser_Issues;

MSQUERY RESULT

http://xxxxxx/im/WebClient?IssueID= 1 (Note the spaces between the
and the 1.

Any ideas how to get rif of she spaces in MS Query

 

[onedaywhen]

Can't reproduce, the ampersand ('&') works for me. You provide no
hints to schema so I'll use northwind.

When the column is integer:

SELECT 'http://xxxxxx:9001/im/WebClient?IssueID='&Employees.EmployeeID
FROM `C:\Program Files\Microsoft Visual Studio\VB98\NWIND`.Employees
Employees

results

http://xxxxxx:9001/im/WebClient?IssueID=1

When column is text:

SELECT 'http://xxxxxx:9001/im/WebClient?IssueID='&Customers.CustomerID
FROM `C:\Program Files\Microsoft Visual Studio\VB98\NWIND`.Customers
Customers

results

http://xxxxxx:9001/im/WebClient?IssueID=ALFKI

Same results from Excel worksheets where the columns are integer and
text respectively (i.e. format and values).