Re: How to convert an integer to a string

I think I get a *Double* as the subquery result (SELECT COUNT(*) FROM
ProdCat WHERE ProdCat.Pcat_VendID=Vendors.Vend_ID).

If I substitute this subquery with the column name of another
text-based, the sql statement executes without problems. It also
concatenates in the way intended.

This is the reason why I think it is necessary to convert the subquery
result to a string. but c# code does not work on the sql statement, and
I thought it would be likely that access has some function for this. I
have not been able to find this function on the access help file either.

.

Relevant Pages

  • Re: Using Execute SQL Task to insert rows
    ... I still can't see why this error message is relevant to my SQL. ... > www.SQLDTS.com - The site for all your DTS needs. ... >> Subquery returned more than 1 value. ... >> Here's my SQL statement: ...
    (microsoft.public.sqlserver.dts)
  • Re: Another sequential query field problem... are you out the Duan
    ... You seem to have seen some solutions that involve a subquery. ... attempted in terms of your SQL statement and results? ... >> Duane Hookom ... >>> What I need to do is creat a field in my query that creates a sequence ...
    (microsoft.public.access.queries)
  • Re: Nasty Query Here
    ... You are using a UNION between the two halves of the SQL statement, ... You are using TRUNCin the subquery, ... email returned from the inline view is null or not. ...
    (comp.databases.oracle.misc)
  • Re: Ranking Dates
    ... Which way to ranking goes doesn't matter. ... Here is my SQL Statement. ... This subquery is returning the count of records for which the invoice date is ...
    (microsoft.public.access.gettingstarted)