DLookup with 2 conditionals

[charly.csh]

Hi everyone,




I want to join two conditions for my DLookup but after trying I couldn't

How Can I joint this two conditions? ... I tried with "And" but I cound't make it work

'************************************************* ********************************
Me.EquipoM = DLookup("[Name]", "[Work_Team]", "[LineProduction]= '" & Me.Line_Production & "'")
Me.EquipoM = DLookup("[Name]", "[Work_Team]", "[Departament]= 'Production'"

[Micron]

Why not post what you tried and we can probably advise where you went wrong? I'm thinking you might learn more from that exercise.
If you prefer, I or someone else can probably just do it for you.

EDIT - make sure your object names are consistent e.g. "Departament" looks misspelled here.

[charly.csh]

Yes you're right the idea is to learn and I made that but it did'nt work

This is what I did...

Me.EquipoM = DLookup("[Name]", "[Work_Team]", "[LineProduction]= '" & Me.Line_Production & "'" And "[Department]= 'Production'")


I edited... 'Departament... good point

[Micron]

The ampersand is the concatenating operator, yes? And each parameter of the function needs to be enclosed in quotes. Your "And" is part of the last parameter (the criteria portion) but it lies outside of your quotes. It's kind of 'orphaned'. I think this is more like what you need (I didn't know what to do with department now so I left it as is):

Me.EquipoM = DLookup("[Name]", "[Work_Team]", "[LineProduction]= '" & Me.Line_Production & "' AND [Departament]= 'Production'")

I have to assume that [Departament] is a field in the table, not a control on the form. Hopefully that expression is correct. One way to check your work and trouble shoot is to replace what comes between the quotes with literals. If I do that, the expression should evaluate to (the value I chose isn't important to the explanation):

Me.EquipoM = DLookup("[Name]", "[Work_Team]", "[LineProduction]= 'Production1' AND [Departament]= 'Production'")

2 other comments
- you don't allow for the possibility that the lookup could return Null (or at least it's not obvious)
- I'm assuming the criteria values are text. If not, they may need some other type of delimiting, just not a single quote. Numbers don't get delimited.

[charly.csh]

Oh sorry Department is also a field that belongs to the same table "[Work_Team], so both criteria belongs to the same table.

Departments according to the data contained into the table could be.... Quality, Production, Engineering, Human_Resources, etc

It makes a change into my criteria?

[Micron]

Not sure what you are saying/asking because I get that both fields are in the same table. The change it has on your criteria expression is relevant to how it needs to be concatenated.