OHHHHHHHHH NO

-----------------------

Server: Msg 7321, Level 16, State 2, Line 1

An error occurred while preparing a query for execution against OLE DB provider 'msidxs'.

OLE DB error trace [OLE/DB Provider 'msidxs'...

ok thnks but i have an error

---------

Server: Msg 170, Level 15, State 1, Line 4

Line 4: Incorrect syntax near 'C:'.

Server: Msg 105, Level 15, State 1, Line 5

Unclosed quotation mark...

THIS IS MY ERROR :

--------------------

Server: Msg 7321, Level 16, State 2, Line 5

An error occurred while preparing a query for execution against OLE DB provider 'msidxs'.

[OLE/DB provider returned message:...

thnks but i have an error

---------------

Server: Msg 174, Level 15, State 1, Line 16

The substring function requires 3 arguments.

thnks

ilan

forgiveness the code is ok

thnks agin for your help

ilan

problem with the code

---------

Server: Msg 208, Level 16, State 1, Line 1

Invalid object name 'dbo.Revenue'.

Server: Msg 208, Level 16, State 1, Line 1

Invalid object name 'dbo.Table1'.

------------------------

thnks agin ilan

thnks

help agin

----------

and if i have the code like this how can i put your code here

-----------

SELECT dbo.Table1.Field1, dbo.Revenue.Services

FROM ...