By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,534 Members | 1,807 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,534 IT Pros & Developers. It's quick & easy.

Updateable query

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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


Nov 13 '05 #3

P: n/a
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



Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.