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:
1I 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?
2Is 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