How to create a search with criteria (1 Viewer)

[treegi]

Hi everybody. I have this question in my hand:

"Create a search for a customer enquiry. When run, this will prompt for the Region to be visited and the number of passengers.

The search should display the results for all boats in the chosen Region where the number of Guests is greater than or equal to the number of passengers entered. "

I know how to create a search for Region. Simply i put [Enter the Region name] criteria under the Region field. But i dont know how to create a search for number of passengers. Can anyone please help me on this.

Thanks a lot.

 

[Galaxiom]

In the criteria for the number of passengers field type:
>=[Enter the Number of Passengers]

 

[treegi]

In the criteria for the number of passengers field type:
>=[Enter the Number of Passengers]

..and this solves my problem. Thanks a lot. I really appreciate your help.

 

[mohsin_masood91]

In the criteria for the number of passengers field type:
>=[Enter the Number of Passengers]

I have the same question as the OP "create a search...." .What I want to know is that,how can I do it ? I'm really confused.I know it's easy but how do I create searches in access ? I know they meant to use forms by it.But how can I use forms to create searches ?

 

[Steve C]

I found this useful when creating a search form

http://www.access-programmers.co.uk/forums/showthread.php?t=188663