Updateable query

[Ray]

I have below query in Access 97 but it is not updateable by entering
or editing data in the query. Can someone advise how to modify it to
be updateable one.

SELECT [Shipping data].PCode, [Shipping data].Model, [Shipping
data].Description, [Shipping data].DatePorductionStarted, [Shipping
data].EstimatedShipDatePerSupplier, [EstimatedShipDatePerSupplier]+30
AS
Period, [Merchase Area].[Merchandise Area] AS Category, [Merchase
Area].[Code No]
FROM [Shipping data] INNER JOIN ([Merchase Area] INNER JOIN [Product
information] ON [Merchase Area].[Code No] = [Product
information].[Merchanise Area]) ON [Shipping data].PCode = [Product
information].PCode;

Thanks,

Ray

[PC Datasheet]

Remove both aliases (As) and the +30 and your query should be updateable. As for
the +30, handle that in your form or report.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Ray" <ra*******@yahoo.com.hk> wrote in message
news:d3**************************@posting.google.c om...

I have below query in Access 97 but it is not updateable by entering
or editing data in the query. Can someone advise how to modify it to
be updateable one.

SELECT [Shipping data].PCode, [Shipping data].Model, [Shipping
data].Description, [Shipping data].DatePorductionStarted, [Shipping
data].EstimatedShipDatePerSupplier, [EstimatedShipDatePerSupplier]+30
AS
Period, [Merchase Area].[Merchandise Area] AS Category, [Merchase
Area].[Code No]
FROM [Shipping data] INNER JOIN ([Merchase Area] INNER JOIN [Product
information] ON [Merchase Area].[Code No] = [Product
information].[Merchanise Area]) ON [Shipping data].PCode = [Product
information].PCode;

Thanks,

Ray

[Ray]

PC Datasheet,

Thanks for your advice. I can remove +30 but cannot remove both aliases
(As) as I need them as criteria to query the table. Any other options?

Ray

"PC Datasheet" <no****@nospam.spam> wrote in message
news:SF*****************@newsread2.news.atl.earthl ink.net...

Remove both aliases (As) and the +30 and your query should be updateable. As for the +30, handle that in your form or report.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Ray" <ra*******@yahoo.com.hk> wrote in message
news:d3**************************@posting.google.c om...

I have below query in Access 97 but it is not updateable by entering
or editing data in the query. Can someone advise how to modify it to
be updateable one.

SELECT [Shipping data].PCode, [Shipping data].Model, [Shipping
data].Description, [Shipping data].DatePorductionStarted, [Shipping
data].EstimatedShipDatePerSupplier, [EstimatedShipDatePerSupplier]+30
AS
Period, [Merchase Area].[Merchandise Area] AS Category, [Merchase
Area].[Code No]
FROM [Shipping data] INNER JOIN ([Merchase Area] INNER JOIN [Product
information] ON [Merchase Area].[Code No] = [Product
information].[Merchanise Area]) ON [Shipping data].PCode = [Product
information].PCode;

Thanks,

Ray

[PC Datasheet]

Ray,

I hope I didn't mislead you about the +30 and the aliases!

<< [EstimatedShipDatePerSupplier]+30 AS Period>>

Just make it: [EstimatedShipDatePerSupplier]

<< [Merchase Area].[Merchandise Area] AS Category

Just make it: [Merchase Area].[Merchandise Area]

Steve
PC Datesheet

"Ray" <ra*****@hkbn.net> wrote in message news:ce***********@news.hgc.com.hk...

PC Datasheet,

Thanks for your advice. I can remove +30 but cannot remove both aliases
(As) as I need them as criteria to query the table. Any other options?

Ray

"PC Datasheet" <no****@nospam.spam> wrote in message
news:SF*****************@newsread2.news.atl.earthl ink.net...

Remove both aliases (As) and the +30 and your query should be updateable.

As for

the +30, handle that in your form or report.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Ray" <ra*******@yahoo.com.hk> wrote in message
news:d3**************************@posting.google.c om...

I have below query in Access 97 but it is not updateable by entering
or editing data in the query. Can someone advise how to modify it to
be updateable one.

SELECT [Shipping data].PCode, [Shipping data].Model, [Shipping
data].Description, [Shipping data].DatePorductionStarted, [Shipping
data].EstimatedShipDatePerSupplier, [EstimatedShipDatePerSupplier]+30
AS
Period, [Merchase Area].[Merchandise Area] AS Category, [Merchase
Area].[Code No]
FROM [Shipping data] INNER JOIN ([Merchase Area] INNER JOIN [Product
information] ON [Merchase Area].[Code No] = [Product
information].[Merchanise Area]) ON [Shipping data].PCode = [Product
information].PCode;

Thanks,

Ray