Bind a TextBox to a specific row in a query

A

AntonioRio

I have a table containing several Projects and its Phases.

I made a query that Counts the total of projects in each phase:

Query_Projects_Phases

Phase CountOfPhase

Pre-project 1
Portfolio 45
Execution 7

Now I need to create TextBoxes in a Form to return the totals for each
phase. This means I need 3 TextBoxes.

One would be bound to the "Pre Project" CountOfPhase field from the query
(in this case 1);

the other would be bound to "Portfolio" CountOfPhase field from the query
(in this case 45) and so on...

I don't know how to do this.

Thanks for your time and help.
 

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

Bind a Textbox in a Form 2
Bind TextBox to a specific row in a query 4
Return certain row result from a Query 1
Group results in query 9
query returns in different columns projects from different phases 4
Mail Merge query 1
Access Select Query Count 3
Help needed: How to adjust the SUM range??†0

Top