Need help with a Delete Query

[maximus92]

I know there is a simple solution to this, but I'm not well versed enough in Access to know the answer. I work in a prison as the "IT" guy, my weakness is programming. Basically I'm the Computer repair guy.

Anyhow, I have two Db's, one is a Db used by the Housing Units to keep track of the inmates, what cell they're assigned to, thier jobs, and when they go to medications. The other Db is our Main inmate Db that keeps track of all the inmates in the institution. I've linked the Housing Unit Db to the main inmate table in our Main Inmate Db. This pulls the inmate's number, Last Name, First Name, cell location, job, and pay rate. However details like days off, the hour the inmate reports to work, and medication details have to be entered manually.

The problem I'm having is when the delete query runs it deletes everthing. Now I know I need to get the query to look at say the inmate's number and the the cell location, and if the cell location no longer matched delete that entry, I just don't know how to express that in the query.

If I can get this working, I'll have an append query question, and you may be able to figure out what I'm going to ask.

 

[pbaldy]

You need to add a criteria. In SQL view what you have now probably looks like:

DELETE * FROM TableName

and you want

DELETE * FROM TableName WHERE FieldName = 123

In design view you can put the value(s) in the criteria row under the appropriate field. You can also point them to a form field to make it more dynamic.