Paul Liadis
pnl1 at psu.edu
Wed Nov 12 15:05:45 CST 2003
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