pull numbers from a field for report

R

rhon101

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.
 
R

Rob Parker

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top