[AccessD] Re: SQL Syntax in Access 2000

Wed Nov 12 15:27:52 CST 2003

UPDATE [Tmp Master Budget Table]
SET [Tmp Master Budget Table].FundTypeIbis =
[ib_header_hist].[CODE_ICOA_FUND_TYPE]
from ib_header_hist
where [Tmp Master Budget Table].NumbAcct = ib_header_hist.NUMB_ACCT

                    "Paul Liadis"                                                                                                
                    <pnl1 at psu.edu>                   To:     "Access Developers discussion and problem solving"                  
                    Sent by:                          <accessd at databaseadvisors.com>                                             
                    accessd-bounces at databasead       cc:                                                                         
                    visors.com                       Subject:     Re: [AccessD] Re: SQL Syntax in Access 2000                    

                    11/12/2003 03:05 PM                                                                                          
                    Please respond to "Access                                                                                    
                    Developers discussion and                                                                                    
                    problem solving"                                                                                             

Here is the statement that will run in SQL Server  2000 but not  Access
2000:

UPDATE [Tmp Master Budget Table]
SET [Tmp Master Budget Table].FundTypeIbis =
[dbo_ib_header_hist].[CODE_ICOA_FUND_TYPE]
from dbo_ib_header_hist
where [Tmp Master Budget Table].NumbAcct = dbo_ib_header_hist.NUMB_ACCT

Thanks,
Paul Liadis

At 02:05 PM 11/12/2003 -0600, you wrote:
>Send your statement that is not working and we can tell you why it is not.
>
>At 12:00 PM 11/12/2003 -0600, you wrote:
>>Date: Wed, 12 Nov 2003 11:39:12 -0500
>>From: Paul Liadis <pnl1 at psu.edu>
>>Subject: [AccessD] SQL Syntax in Access 2000
>>To: Access Developers discussion and problem solving
>>         <accessd at databaseadvisors.com>
>>Message-ID: <5.1.0.14.2.20031112113630.0346feb0 at mail.psu.edu>
>>Content-Type: text/plain; charset="us-ascii"; format=flowed
>>
>>Hi,
>>Is there a place where I can find the SQL syntax that Access uses in the
>>SQL view of a query?  I have an SQL statement that does an update in SQL
>>Server 2000 that will not run in Access (copy and paste to the SQL View)
>>due to a "syntax error".  Any help would be greatly appreciated.
>>Thanks,
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com