Beginner needs help with searching a range of values

[dave897]

Hi,

Im a web designer by trade and know pc's fairly well, im trying to help a friend who is pc illiterate build a database.
It would help him out and be some practice for me (always wanted to have a bash at access but never had a reason to do so)

Im totally new to Access and im trying to do the following.

He is an estate agent and wants a database where he can enter his prospective clients looking for commercial properties to rent, one of their criteria will be the size range of the property they want. Then when he gets a new property on his books he wants to be able to search the client list by the size of the property and display the results of any clients that the properties size falls within their required size range (phew hope that makes sense)

In an ideal world hed like the results to include addresses so he can mail merge the results and send out letters to any clients who might be interested.

So, ive managed to create a table of all his client details but now im stuck on how the query should work, ive read the help files in access (which seem to be written in martian) and im just not sure how i should try and do this. I started to create a parameter query but ive gotten very confused with all the options.

I can see that i could put fields in my table of Min Size and Max size but im not sure how to design a query that searches a single value between these 2 fields

Ive had a look through this forum but cant see anything that covers this, im hoping someone might be able to point me in the right direction, either with some advice or a link to some online help that might help me understand what i need to do.

Thanks for taking the time to read this post, apologies if its in the wrong place or a totally noob question.

Any help would be very much appreciated

Many thanks
Dave

 

[naminder]

hi

it would probably be better if i understand correctly to create a field in the client table called something like size of property required. then come up with a list. eg small, large, mansion etc.

then when you create a property give it a size of these. small, large, mansion etc.

create a table that contains these property sizes. e.g tblPropertySizesLookup

then you can easily design the query to bring up all large propertys

maybe this helps...

 

[KenHigg]

Dave,

If you have a fld for the house size, when you do a search, you could simply do something like greater than or equal to x and less than or equal to y.

Make sense?

 

[dave897]

thanks

Hi, thanks for your quick responses

ive tried it the way you suggested naminder and that works fine, thanks for that , problem solved

thanks for your suggestion too ken

blimey these databases are tricky stuff, im sticking to HTML

Thanks again for all your help guys, much appreciated

 

[naminder]

no probs. remember to think logical. keep it simple....

 

[KenHigg]

I would have thought that a square footage for the size type deal would have worked best