Display query value on a form

[mveijndh]

I've created two query's generating the total order value and total invoice value for a year. The query is fine and generates the correct value. Now I want to display these values on a dashboard providing me an overview of my year to date results, but the values are not displayed but an error message is displayed #Name
Data Source=[queDashOrderSum]![TotalOrderYear].[Value]
Data Source =[queDashInvoiceSum]![TotalInvoiceYear].[Value]

 

[arnelgp]

use Dlookup() function as your controlsource:

=Dlookup("TotalOrderYear","queDashOrderSum")
=Dlookup("TotalInvoiceYear","queDashInvoiceSum")