Top 10

Dear Hakeem

Thank you for attending Access Introduction course!! I hope you enjoyed the course and benefited from it.

I am not 100% sure what is it that you are looking to achieve from the query. I'll try to guess to the best of my ability and also provide an answer for it. If it doesn't answer your question I would request you to reply and may be provide some example to make things a bit more clearer for me.

I assume that what you want is that whenever somebody enters an amount the results that display matches the criteria that the user enters.

To do this you would have to create a Parameter query. This is normally covered in our Intermediate course but they are quite easy to create.


Let's assume that you have the following fields:

Name DOB Salary


Let's assume that you have various records in these fields.

You would create a new query.

Download the fields in the grid box so that they appear in your result view.

Let's assume that you wanted to put a criteria for salary where whatever value the user enters when they run this query the result that appear match that and any salary which is greater than that value.


In the Criteria box for the salary you can simply type in >=[Please enter Salary which equals or is more than]

Please note that Square brackets need to be used.

If you wanted less than or equal to the salary then you would simply replace >= with <=

If you wanted the user to enter two separate values and get all the salaries between these two values then you would put the following in the criteria box of the salary field:

between [Please enter the lower value] and [Please enter higher value]

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Dear Hakeem

Reffering to my earlier post I am very sorry because I started talking about Excel when the question was more related to Access!!

I think you'll have to give me an example of this so that I can be clear before giving you the relevant answer!!

Don't worry I'll try to stick to MS Access this time and not MS Excel :)



Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007