Dashboard Design

[Raddle]

Hi

Am trying to pull together a dashboard, on which I'd like to have several pieces of information displayed.

however, a form is bound to a query I think so I may not be able to say have table A data and table B data summaries on the same page.

Is there a way around this?



Can I just plop a few labels on the form, with some free SQL which pulls data out as needed and displays it?

Thanks in advance.

[pbaldy]

Sounds like subforms would solve your problem.

[Minty]

A form doesn't have to be bound to anything.
Create a bunch of summary queries and then pull the data from them. You can do that onto a sub form if it's say a "Top 10 Clients" list, or if it's simply single line points of interest (Value of x this month) use a DLookup() from a summary query or a Dsum() to get the number into an unbound control on your dashboard.

[Raddle]

So I created a query to count the unique records in my main table.

And then on a form I inserted a text box with the following Control Source

=DLookUp([qry_CountMainData],[fieldnameIcounted])

..but I get ?Name error.

Any hints ?

[Welshgasman]

Need to surround the paremeters with double quotes?

Why not look up the syntax?

https://support.microsoft.com/en-au/...b-bed10dca5937

[Raddle]

Thanks for that and appreciate the syntax steer.

=DLookUp("[fieldnameIcounted]","qry_CountMainData")

So the first arg is the field from the query where I counted the records, so the query returns a single number
The second is the query name
As there is no criteria I left that out

Now I get a new error, which actually states #Error

Am I on the right track at least?

[Welshgasman]

You have an I in there? for the fieldname/alias. The names have to match.
Could likely use Dcount() with "*" for first parameter.

[Raddle]

I was masking the actual field name. I have to do that or I might get a done away with !

So, this is good now. I went back to Dcount * as you suggested and got a result! So exciting, seriously.

My plan now, is to tip a few of these on to a form so we can see %s of various things, and left to do counts etc

You have helped immensely! thank you.

Case closed