Query Question

[data808]

When I do a query it shows the data in a datasheet view. Very much similar to a table view. My question is, if I am in a query and I edit something by accident in the datasheet view will it reflect in the table? Does it save the changes made in query mode? Or is query strictly for viewing and if you should edit anything in query mode then it won't save?

[June7]

Data entry/edit can be done through queries. Not all queries allow editing but when they do, the edits will be reflected in the table.

[data808]

how do you turn off editing in a query?

[June7]

You don't. Some queries by their nature will not allow data edit. A simple SELECT query is always updatable.

[data808]

what is a SELECT query?

[June7]

Example:

SELECT * FROM MyTableName;