Edit Query

[Anthony]

I have a query that pulls data from a master table. Is it possible to edit
information in this query?

 

[Duane Hookom]

Maybe. Try it and if you can't, come back with some information about the
query, your tables, and primary/foreign key fields.

 

[Anthony]

I have a master table with 4 different types of data. The ID # is set as the
primary key. Each data type has its own query. I would like to be able to
run the query & edit/update the information in the query instead of the
table. The query in question pulls duplicate records. I want to be able to
delete the records in the query.

 

[Armen Stein]

I have a query that pulls data from a master table. Is it possible to edit
information in this query?

Most basic queries allow the data to be edited. Just try it and see.
If the table is editable, a query based on it usually is also.
Remember that when you edit data in a query, you are actually changing
the data in the original table. Queries themselves do not store data,
they only rearrange and present table data to you.

If the data can't be edited, it's usually because you've made it a
Totals query, you've joined to a Totals query, or your joins are too
complex. Try simplifying things until you figure it out.

Or instead of updating values in a query, build a form instead -
that's the preferred way to work with data anyway.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[Duane Hookom]

I'm not sure how a "data type has its own query". Can you provide some SQL
views and table structure specifics?

You should use forms for all user interface.