Result of a query record count in a text box

[MAVIS]

Can anyone help ? I am a new beginner on the Database/Access scene and my question is this... How do I display the total number of records from one of my tables (tbl STAFF) so that it is displayed as a 3-digit number in a separate text box. What I would like to have is a series of text boxes that automatically display this type of data from a variety of other tables on initial load up of my form. I have created a query which gives me the records total via a field but I would simply like the number to appear in it's own text box without having to invoke a manual query each time. Is this possible and if so how do I go about setting it up. I've only been signed up to this great site for less than a week and once again I find myself asking basic questions. Hope someone can help - Many thanks to Col for your help last time...it worked and was much appreciated.

Mavis

 

[Taff]

Hi Mavis,

Try putting the following as the control source of your text box:-

=Format(Dcount("Your Field Name Here","Your Table or Query Name Here"),"000")

Hope this helps


Taff

 

[MAVIS]

Taff,
Many thanks for your advice on the above subject -it works a treat!

Mavis