> I am trying to create a view in MS ACCESS and am getting the following error:
>
> [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
> Access Driver] Syntax error in field definition.
>
> Here is the create statement. I've tested the select portion separatey and
> that works.
You are using a mixture of a create view and a create table
statement. Try a regular create view statement:
CREATE VIEW vieInvoices AS
SELECT
tabOrders.Customers_FK AS CustomerKey,
vieCustomerList.CustomerName AS CustomerName,
IIf([PeachtreeInvoiceNumber] Is Null,
[tabInvoices].[InvoiceNumber],[PeachtreeInvoiceNumber]
) AS Invoice
etc.
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
