Sorry, I was assuming that the new columns were being added on the SQL Server and the changes were then passed on to the Access interface.  I've never tried it...

Just curious to see what the actual strings being tested in the WHERE clause are.  This can be seen by removing the date comparison for the moment and adding visit_date, @MinusDate, and convert(varchar(10),visit_date,101)...

Try the CONVERSION in the WHERE clause.  Try it there, if it doesn't work then throw the results of the converted visit_date and @MinusDate into the SELECT clasue and let us...

Sorry, I was thinking WHERE clause.  Try it there, if it doesn't work then throw the results of the converted visit_date and @MinusDate into the SELECT clasue and let us know...

Is visit_date in the same format as @MinusDate?  I'm thinking if visit_date is a datetime field then you'll need to convert it to a varchar (of type 101).

how about building the query:

DECLARE @Query varchar(8000)

Set @Query = ' SELECT  DISTINCT inv.ProductID,

 -- MAX(pl.WebCatID) AS CategoryID,

  left(WebDesc,255) AS ProductDesc,

  inv.ListPrice,

  inv.Hyperlink,

  ATP.ATP AS Stock,

  inv.Discontinued,

  inv.PriceList,

  inv.Recommended,

  NONstockable,

  inv.ImageFilename,

  ft_inv.RANK

 FROM

 (IN_PROFIL AS...

This can be done via a linked server (see BOL).  The syntax is easy

  SELECT ID

  FROM [servername].[dbname].[owner, usually dbo].[tablename]

or

SELECT ID

FROM testserver.Northwind.dbo.Orders

This can be used to also join tables from multiple servers...

Hello.  I'm having trouble seeing the full set of circumstances so I'm making some assumptions here.  Please let me know if I'm still off and how, some days the clouds...

how about identify 'bob' and then remove him from the final list, sorry in advance for any syntax errors.

select *

from xtable

  left join

 (select ID

 from xtable

 where Canned = 'bob')

 as xbob

   ...

Not quite sure what you need, does this get you started?

use Northwind

select CustomerID

from

 (select CustomerID, Count(OrderDate) AS Instances

 from Orders

 where OrderDate > '8/15/96'

 group by CustomerID)

 AS CustomerOccurrences

where Instances >= 5

The recreate the link strategy should've worked.  When you create the new link can you open the table and view the contents?  If you can't then there's a connection issue,...

Disclaimer #1 goes me too ... some day they'll make the mistake and give me too much power ...

If the linked server has the proper permissions then you should be...

Although I havn't done this I do run an executable each night that check's for data integrity issues between an SQL table and an Exchange Server using Web DAV.  Unfortunately...

The cumbersome way of using syscolumns was mine until I saw iLoveSQL's post yesterday.

Object_Name doesn't quite cover it, after all.

Hello.  Usually when I do a onetime shot I jus throw in a variable that I don't have to think about, using estimation as a guide (50,500,1000,2000,5000).

Good point about avoiding the...