Query to report question.

[TYLER_DURDEN_SOAP]

I currently have a report that was developed from a query. The repor
is built off of which doctors name I place in the search query. Wha
I need is to produce the query from the doctor's name, but only o
the records that the field "Pending MEB" is checked

 

[David Lloyd]

I would add an additional criteria to the WHERE clause. Something like:

WHERE Name=[InputName] AND [Pending MEB]=True

This assumes Pending MEB is a true false field. If it is not, you will have
to adjust accordingly.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


"TYLER_DURDEN_SOAP" <[email protected]>
wrote in message I currently have a report that was developed from a query. The report
is built off of which doctors name I place in the search query. What
I need is to produce the query from the doctor's name, but only on
the records that the field "Pending MEB" is checked.

 

[TYLER_DURDEN_SOAP]

THanks, but I still need more help
What I currently have in my query is this

Field: Patient's PCM
Table: 4T Master
Sort:
Show: checked box
Criteria: [Enter PCM Name]

Field: Pending ME
Table: 4T Maste
Sort:
Show: checked bo
Criteria

Ok that is what the two sections look like for those two fields
obviously there are other fields for name, rank, etc. Th
information you showed me above, I don't understand how that i
fitted into the current query setup. Just so you know when I mak
the report by PCM, I actually type in the name of the Doc so it wil
find records under his name. Need to know how to make it only pul
his records that have been checked in the Pending MEB field. THan
you

 

[LMid]

Field: Patient's PC

Table: 4T Maste
Sort
Show: checked bo
Criteria: [Enter PCM Name

Field: Pending ME
Table: 4T Maste
Sort
Show: checked bo
Criteria:

The criteria for Pending MEB should be true

Field: Pending ME
Table: 4T Maste
Sort: checked bo
Criteria: tru

True should not be in quotes

 

[TYLER_DURDEN_SOAP]

hmm