Return certain row result from a Query

A

AntonioRio

I have a query that counts the total of projects by phase and area:

Query_Projects

Project_Phase Area CountOfPhase
Pre-project DIFN 11
Pre-project Others 2
Portfolio DIFS 7
Portfolio Others 9
Execution DIFN 4
Execution Others 9

Now I need a textbox in a form to bring the quantity of projects in a
certain Phase AND in a certain Area.

I tried
=DLookUp("[CountOfPhase]";"[Query_Projects]";"[Phase]='portfolio'";[Area]='"DIFS")

in order for the textbox to return the quantity (CountOfPhase =7 in this
case) for projects in Portfolio phase AND that takes place in DIFN area.

I think the syntax is wrong because this is not working.

Thank you for your help.
Antonio Machado
 
M

Maurice

Try this:

=DLookUp("[CountOfPhase]";"[Query_Projects]";"[Phase]='portfolio'" & AND
"[Area]='"DIFS")
 
Top