pull numbers from a field for report

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

Guest

I am trying to query a table to pull a list of numbers. The table is entered
by a form and consists of EmpID, Date, ICN, ErrorCategory, ErrorSection,
Edit_Audit, Num_Errors. The Edit_Audit field contains the edit or audit that
pertains to each error. For example, one employee could have a total of five
errors for the month. 1 error for the 275 audit, 1 for the 631 audit, 2 for
the 043 edit and 1 for the 924 audit. The edit/audit number is an identifier
for how to resolve coverage issues on procedure codes. Out of all the
edits/audits there are a select few that are MR (Medical Review)
edits/audits. I want a report that will pull all of the MR edits/audits only.
Like;
Edits/Audits MR Edits/Audits
023 055
055 199
199 570
277
352
570

How do I pull only the MR Edits/Audits from the Edits/Audits list. I tried
to query using LIKE but the MR Edits/Audits list contains approx. 45 numbers.
 
You could set up a table containing the code numbers for the MR edits/audits
(a single field table), and join that to the code field the main table in
your query, using an inner join (the default in the query builder). This
will limit the records from the main table to those where the code is an MR
code.

HTH,

Rob
 
Back
Top