Queries that works with calculation fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that add lines into a table, but I want that this same query
also changes the data in the table when is necessary. Right now the query is
giving me a new line with the same id and the new data. The problem with that
is that I have calculation queries link to that table and if I have 2 lines
with the same id and different data that may cause problems.
 
You can perform an Update or an Append, but not both at the same time. At
worst, you may have to do two queries. One for the matching, and one for
the new records.
 
In this case I would have to make a copy of the existing query and make it as
an Update query. The other problem a have than is that I would have to do
another form based on an updated query or the form already update the
database?. In the case of having to do another form how you I look the old to
work only as data entry and make it unable to edit already save data.

"[MVP] S.Clark" escreveu:
 
Back
Top