can't execute update query

  • Thread starter Thread starter Daniel Collison
  • Start date Start date
D

Daniel Collison

Query A identifies a subset of admission episodes (“Admission Episodeâ€) that
include patient discharges prior to 6/30/08 . Table AA includes a universe
of all admission episodes (“ID Admissions Episodeâ€).

I want to create a second query, Query B, to update field “Discharge b4 year
end†in table AA. The field has a “yes/no†data type.

In update query B, I included table AA and query A. “ID Admissions Episodeâ€
from table AA is linked with “Admission Episode†from query A. The join is
join 1 (joined fields from both tables are equal).

“ID Admission Episode†and “Discharge b4 year end†are both included as
fields in the query. The criteria for “ID Admission Episode†is [query
A]![Admission Episode]. The “update to†value for “Discharge b4 year end is
“yesâ€.

When I attempt to execute query B, the following message is returned:
“operation must use an updateable query.â€

The values in query A are all unique, as are the ID Admissions Episode
values from table AA. The same error message resulted when I changed the
join property to option 2 or 3.

Any suggestions on what needs to change so that the query can be executed?

Thanks,
 
As you say that Table AA includes a universe
of all admission episodes; then I presume that QueryA is sourced on this
Table AA.

If so then you don't need QueryA in your UpdateQuery...you just need to put
in the criteria of the PatientDischargeDate field:
<6/30/08
 
Back
Top