Help!!

[crystalda726]

I thought if you made a Query from a table, the Query did not affect the table in any way. I deleted information from the Query and now it is gone in the table. Does anyone have any information on this? This is 4 months worth of information! Please help if you know anything

 

[pbaldy]

You now know that you were wrong. A query can affect the data in the table. Hopefully you have a good backup available. You can avoid this in the future by setting the "Recordset Type" in the query properties to Snapshot.