Display number of counted items in Textboxes

[Lensmeister]

Hi all,

Can you guys help me out with this.

I want to create a form in Access 2002 (old I know) that displays the following items.

txtTotalRecs: This is ALL the records in the tbl_CoreDB
txtTotalATH: This is the count of all records in the tbl_CoreDB in the field LGE that meet the criteria ATH.

I will be creating a number of other textboxes based on txtTotalATH for various other criteria.

I am at a loss as I have not done anything with Access in a long time.

Thank for all you help in advance.

L.

 

[bob fitz]

Perhaps the DCount() function would be of use.

 

[Lensmeister]

Perhaps the DCount() function would be of use.

Thanks,

So if I put a textbox on the form, I put DCount(*) in the control source ?

Sorry,

I haven't done anything in Access in a long while and despite being good with Excel, Access is has always been a mystery to me.

 

[bob fitz]

This is untested, but I was thinking of something like:

Control Source for txtTotalRecs:
= DCount("NameOfField","the tbl_CoreDB")

Control Source for txtTotalATH:
= DCount("LGE","tbl_CoreDB","LGE = 'ATH'")

 

[Lensmeister]

AWESOME ... thank you it works perfectly