Problem (Search Criteria)

[Reety]

I have a "Property Search Screen" that links to a "query" as parameters are entered, different viewings of properties will come up that fit the parameters:



Example, If i want to buy a house with a garden, the query would only show houses with gardens. Or if i enter a minimum price of 250,000 only houses that are 250,000+ will show.

My question is: as the parameters are entered, my teacher wants an indicator displayed on the screen to show how many properties match the search criteria. This should update dynamically.

Thanks for the help and your time
Reety.

[orange]

The screen is a form.
You add a field/text box control on the form.
When you finalize the query based on your parameters and the values selected, you could
count the records that qualify and place that number in the text box.

This should give you a dynamic value that is dependent on the number of records that meet you search criteria.

Good luck.

[June7]

Try:

Textbox in form footer section with expression: =Count(*)

[Reety]

The screen is a form.
You add a field/text box control on the form.
When you finalize the query based on your parameters and the values selected, you could
count the records that qualify and place that number in the text box.

This should give you a dynamic value that is dependent on the number of records that meet you search criteria.

Good luck.

Try:

Textbox in form footer section with expression: =Count(*)

Thank you, this has helped. I initially started with this, but i'm stuck on the formula like really really badly, is there any possible way someone could look at my database and help me out? My formula is looking like this:

=DCount("*","Instructor","Charge>=MinCharge AND Charge<=MaxCharge
AND [Max Hours]>=MinHours AND Weekends=WETick
AND Gender Like GenderCombo
AND Central Heating=CentralHeatingBox")

[orange]

I don't see why you need to repeat all possible parameters.
I could be very wrong but my first approach would be

=Dcount("*","yourQueryName")

You will dynamically build a query based on parameters/values selected.

[June7]

You can attach file to post. Follow instructions at bottom of my post.