Access Help - how to create filters for queries

[zanat0s]

Hi all,



First of all let me thank preactively the people who will reply to me. I am creating a Database which will allow me to monitor the pending orders situation.

i created a form and designed where people input all the data(like priority, estimated delivery date, total cost, total CBM, contact person, collection) and i formatted the possible values so people can put only specific answers in some choices.

Now i want to ask something.

First of all what kind of queries i can create(please do not flame me). I mean how do queries generally work?
I created a query that gives me the Average order, the Sum and etc.

here are some specific questions:

1 I want to create a query that i input a value(lets say orders for FW 2011) and i see the summary of orders. How do i create the field where I input the value?

2 Is there a way to create a report/query which show all the orders which an estimated delivery(value is date) after a specific date?

i hope some people help and take the time to reply. On the other hand i am reading and researching on my own online

[orange]

Here's a tutorial that may help
http://goldberg.berkeley.edu/courses/msa-labs2/lab5.pdf

Here's one of forms
http://www.brainbell.com/tutorials/m...ith_Forms.html

[zanat0s]

That's not what i am looking for.

i need to have a field(that's a query or a report?)

here the use will give one value and ACCESS will return to him/her the fields which aggree with the filter

[orange]

i need to have a field(that's a query or a report?)

Please explain. I don't understand what this means, nor what you are trying to do.

And this from the earlier post

I mean how do queries generally work?

What range of answers were you expecting? Here's an overview from Crystal's site.

http://www.accessmvp.com/strive4peac...Chapter_02.pdf see page 3.

If you want more on SQL and queries
http://www.w3schools.com/sql/default.asp or
http://www.techonthenet.com/sql/

Or a different approach
http://www.fontstuff.com/access/acctut17.htm

[zanat0s]

Please explain. I don't understand what this means, nor what you are trying to do.

there is text field/button(call it whatever you want) which acts like a filter. Lets say i wanna create a proccess(query?) which will show me all the records which fit the criteria i am looking for example.

example 1 i want to see all the orders for FW 2012 by selecting FW 2012 instead of SS 2012

example 2 i want to see all the orders which cost more than X amount

example 3 i wanna see all the order handled by person X

all the above examples have to do with what i am trying to achieve.

is this clear enough?

thank you again for trying to help me

[orange]

Clearer, yes --

Here's a site with several examples
http://allenbrowne.com/tips.html

Here's another on queries. There are other tutorials here also.
http://www.fontstuff.com/access/acctut17.htm

Use google and do some searching for specific questions/examples.

If you have the MS Access Northwind database there are lots of examples in that database. If you don't have you should locate it, download it and get familiar with it.