Return certain row result from a Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try this:

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