Text Box on form to Show Total Number of Records

[drp]

Hi!

I have a form containing 4 text Boxes txt1, txt2, txt3 and txt4

I want

txt1 show records from table empDetail having age between 18 to 25
txt2 show records from table empDetail having age between 26 to 35
txt3 show records from table empDetail having age between 36 to 45
txt4 show records from table empDetail having age between 46 to 55

Any help will appreciated

Thanking you

 

[David R]

If your tables aren't huge or speed is not a big factor, DCount should do exactly what you want.

 

[drp]

Hi!

Thanking for quick reply

I understand but exactly do not know how to use or write criteria in DCount Function

Pls give me Expression

Thanx

 

[David R]

Help is your friend. http://office.microsoft.com/en-us/access-help/dcount-function-HA001228817.aspx

It'll be something like:

=DCount("[CaseAgeField]", "tableName", "Between 8 and 36")