Results 1 to 6 of 6
  1. #1
    zanat0s is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2011
    Posts
    6

    Access Help - how to create filters for queries

    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

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,848

  3. #3
    zanat0s is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2011
    Posts
    6
    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

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,848
    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

  5. #5
    zanat0s is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2011
    Posts
    6
    Quote Originally Posted by orange View Post
    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

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,848
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Applicable Filters Box
    By Gray in forum Forms
    Replies: 0
    Last Post: 05-24-2011, 07:58 AM
  2. About filters
    By registan in forum Forms
    Replies: 12
    Last Post: 04-09-2011, 08:01 AM
  3. create a composed queries in access-sql
    By mosquito_admin in forum Queries
    Replies: 5
    Last Post: 01-25-2011, 12:42 PM
  4. Using queries to create new table
    By mradel in forum Queries
    Replies: 1
    Last Post: 10-26-2010, 10:34 PM
  5. automatically create queries
    By GEORGIA in forum Programming
    Replies: 8
    Last Post: 01-23-2006, 02:35 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums