CODEWITHSUNDEEP
ms-access
Jamie805
Jamie805

Reputation: 1

Display a count number in a Access Report into a Text Box on Access form

I'm trying to link and display a =Count([last Name]) from an access report into a Text Box which will display it on a form. Without having to open and close the report to see how many enteries are in there. Any help would be much aporia coated

Upvotes: 0

Views: 64

Answers (1)

BitAccesser
BitAccesser

Reputation: 719

Refer to the same recordsource as the report with something like

=DCount("[last Name]","[myQuery]")

where myQuery is the queryname of the reports recordsource.

Upvotes: 2

Related Questions