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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Group results in query 9
Bind TextBox to a specific row in a query 4
Bind a TextBox to a specific row in a query 0
Bind a Textbox in a Form 2
Display weeks from a Milestone 0
query returns in different columns projects from different phases 4
Crosstab Query based on 2 Combo Boxes. How? 17
Use ComboBox to show and fill data in a subform 2

Top