Adding new records to a select query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nate Adams - 12 Jan 2004 12:44 GMT

I am having problems getting my select query to allow me
to add records to it. I made a database to keep track of
inventory. I have a "prototype" system to aid in the
transition and also another system (exact same) that we
are currently using. My current system allows me to add
line items into a query, say for purchase orders, etc.
My prototype does not, the arrow with the aterisk at the
bottom of the query is darkened in. That's the only
difference I can find. How do I fix that? Thanks!

Reply to this Message

Allen Browne - 12 Jan 2004 14:02 GMT

There are many reasons a query may not be updatable, e.g.:
- It performs some kind of aggregation, such as a DISTINCT or GROUP BY;
- It combines different queries - UNION;
- The field list (SELECT clause) contains a subquery;
- The joins and field selection mean you are trying to add new records to
the "many" side.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I am having problems getting my select query to allow me
> to add records to it. I made a database to keep track of
[quoted text clipped - 5 lines]
> bottom of the query is darkened in. That's the only
> difference I can find. How do I fix that? Thanks!

Reply to this Message