Display a Number from a Report into a Text Box

[Jamie805]

Hi,

Im trying to display a =count([last name)] number from a report into a Text Box on a form, so I can see the number without having to open and close this report

[PhilOfWalton]

The report is irrelevant. What is important is the RecordSource of the report. Assuming it has something to do with table of names, you can use the DCount Function.
If you want to count all the names in your table the ControlSource of your text box will be something like

=DCount("Last Name", "TblName")
 

If the count of the names is filtered, we would need to know which names are included.

As an aside, I strongly recommend that you don't have spaces in your field names, because they will have to be enclosed in square brackets thus
[last name]
Better is last_name, but my preference is LastName.

Phil

[Jamie805]

Hi Phil,
I tried your function, but it won't look at the Report or display what I'm looking for.
Comes up with The expression you entered contains invalid syntax

[PhilOfWalton]

What is the name of your table that holds the people's names?

Phil

[Jamie805]

It's a report called Class 1 it has
Last name First name position
And on the top in the header it has
=count([lastname])
I'm trying to get this figure displayed in a text box,
So I don't need to open and close each report to see
How many are in a class

[NeoPa]

Jamie.
Any reference to a report, or any control on a report, will fail unless that report is open at the time it's referenced.

Reports don't contain data. They merely display the data. The report object is a definition of where to find the data and how to display it.

Thus, attempting to reference data from a report that isn't open is entirely futile. I'm afraid you'll need to look elsewhere.

[PhilOfWalton]

Sorry, I obviously didn't make myself clear.
The report is irrelevant, it just happens that it displays the information that you want.
What I am trying to find is the table or query that is used as a basis for your report. When we have that information we can easily get the count of the last names.

At the moment, things are getting confused because in one part of your question you refer to last name with a space, and in your last post you refer to lastname with no space.

I asked for the name of the table that holds the last name information and got no reply. Can't help unless you answer the questions.

Phil

[Jamie805]

My Query
Last Name then in the next column First Name and next column Class, then position in the last column
All I'm asking from the report that's made from this query is to show the amount of people that is in this class to be displayed in a text box separate, but linked to the report.
In the report I have =count([LastName]) as you suggested to join them together. Which gives me the total in the class, but I would like it displayed in a text box outside the report, so each time the class gets updated it will show the amount of people in the class without having to open the Report.
Sorry for the confusion

[Jamie805]

Can you do it from a query then

[NeoPa]

We keep responding in the strongest possible terms that your way of thinking is way off base and that what you're trying to do is impossible to do that way.

There's no sign that you've understood this yet. I can't see why.

[NeoPa]

You can do it from a query or a table. Though a query doesn't store any data either, it does provide data as output.

To help with how to get this information from your existing data though, we'd need some basic details (at least) pertaining to how your data is stored and what data you're actually trying to show.

So far, everything you've explained doesn't really make sense, so it's difficult to work out what you actually want to do.

[Jamie805]

Ok, I'm sorry for the confusion I'm given...
In my query is displayed the total number of people in my report. I would like this total to be visible in a text box if that is possible

[PhilOfWalton]

We are struggling here. Jamie is obviously obsessed with this report.
I think what he's after is

DCount("LastName","WhateverYourSecretTableNmaeIs","Class = " & Chr$(34) & "YourClassFromYourReport" & Chr$(34)
 

As you won't tell us what your table structure is and how you select what class your report is based on, I regret I can spend no further time on this topic.

Phil

[NeoPa]

I get a similar strong feeling that paying attention and actually responding to the many and various prompts is not a strong point. I'll respond again if/when I get a hint that things have changed and you're prepared to put at least a modicum of attention to this, your own question thread.