Dlook for text with 2 criteria (1 Viewer)

theinviter · Oct 15, 2019

HI guys ,
need help please,
i am designing a query for report and i am having field name drug name in query, where the user can enter drug name in the form so what i want is that;
to dlookup for the drug selected by user in Drug list (Table) to match the selected drug with 1- Drug name (text) and 2- chemo_drug (yes/No) and display only drug that match 2 criteria.

i tried this code

DLookUp("[drug name]","[drug list]","[drug name] ='" & [Drug name] & " AND [Chemo_drug]= " & "0" & "'")

but sow no record.

theDBguy · Oct 15, 2019

Hi. What do you get with this?

Code:

 DLookUp("[drug name]","[drug list]","[drug name] ='" & [Drug name] & "' AND [Chemo_drug]=0 ")

isladogs · Oct 15, 2019

Try this

Code:

DLookUp("[drug name]","[drug list]","[drug name] ='" & [Drug name] & "' AND [Chemo_drug]= 0")

However using DLookup in a query will be slow. There may be better ways.
Can you post the SQL for your query

theinviter · Oct 15, 2019

solved thanks guys

Gasman · Oct 15, 2019

I would ask, why are you looking up drug name when you are supplying drug name?

theinviter · Oct 15, 2019

because i need to filter report based on selected drug.

plog · Oct 15, 2019

because i need to filter report based on selected drug.

Whoosh.

If you need to do that, why not just use the selected drug name to do so? What does the Dlookup do?

theinviter · Oct 15, 2019

because i have 2 report each will show data based on check mark (YES/NO) option

theDBguy · Oct 15, 2019

theinviter said:
solved thanks guys

Hi. Glad we could assist. Good luck with your project.

Dlook for text with 2 criteria (1 Viewer)

theinviter

Registered User.

theDBguy

I’m here to help

isladogs

MVP / VIP

theinviter

Registered User.

Gasman

Enthusiastic Amateur

theinviter

Registered User.

plog

Banishment Pending

theinviter

Registered User.

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread