DLookup

Expand please!

D L  O   O    K     U      P

Do your Queries produce a single number each?

Let's see screenshots of what your queries look like. You could use Dlookup, like Alex said, or you could use subreports. There's lots of different ways to do it.

Alex Yes singel number!

Richard Refer to the image each one of the queries is asking a date period.

Leo What I want to do is create a report or dashboard where appear all these queries in one place!

So you can use multiple DLookups to get each one of those
Put them on a Form
Then reference the Form controls on the Report

Can you refer to me what course I have to see to get an idea?

Dashboards

This TechHelp Video might give you some ideas of how to put the DLooikups Alex suggested to use

Donald After I watch the DLOOKUP video i do not believe this can help me to do what I want to do.

Leo Please explain in detail what you are trying to accomplish so we can advise you better.

I would use a DLOOKUP for the queries that return a single value and a SUBFORM or a SUBREPORT for those queries that return multiple items.

Richard Richard hi, The Subform works for my expectative however every time I open the dashboard all the queries ask me for the period of time.  Is there an option where I can enter the period once and notify to all queries that this initial entry affect to all queries?

You need to put the fields on a form for your start and end dates, and then tell the queries to look at that form. See this video: FormName

I created an introductory form where the user will input information about dateFrom and dateTo.  Then i went to the Query and edited the Between filter however I stated to have an error "Invalid bracketing of name [Forms! StatsMain! dateFrom!]" My Between filter says: Between [Forms! StatsMain! dateFrom!] And [Forms! StatsMain! dateTo!]!

What I missing?

[Forms]![StatsMain]![dateFrom]

Thank you now no error occurs however query return with no result.  I am using this in a Between And Function see the criteria: Between [Forms]![StatsMain]![dateFrom] And [Forms]![StatsMain]![dateTo]
What I am doing wrong?

Never mind i found the correct criteria should be: Between [Forms]![StatsMain]![dateFrom]
And DateAdd("d", 1 [Forms]![StatsMain]![dateTo]); What i missed is DateADD("d", 1 befor the the second part of the criteria

I appreciate the help!!!!