Hell all,
I was wondering whether the following is possible in access;
I need to create a form which is able to show the requested information.
Let's say we have a query (which is a combination of five tables) about sales information of a company. It contains the following fields;
CustomerNumber
CustomerName
Country
OrderDate
ItemBought
ItemStatus
I want to create a form, which gives the user the opportunity to;
1. Select customers from a country from a drop down list (let's say the UK)
2. Select a product status drop down list (let's say only Active products)
3. Select a specific period for sales drop down list (let's say Jan-2004 to July-2004)
the form has to perform the following tasks:
1. Give all the CustomerNumber & Customer Numbers in Germany
2. Give all Active products being sold to those customers
3. Given the period specified.....
Is it possible? In a Query it would be possible. But I want use the "fancy" drop down list. (For oracle people, Just like Oracle Report Request).
If it is possible, how do I have to approach it?....VB?...
Any suggestions would be welcome,
tnx,
Zurvy
I was wondering whether the following is possible in access;
I need to create a form which is able to show the requested information.
Let's say we have a query (which is a combination of five tables) about sales information of a company. It contains the following fields;
CustomerNumber
CustomerName
Country
OrderDate
ItemBought
ItemStatus
I want to create a form, which gives the user the opportunity to;
1. Select customers from a country from a drop down list (let's say the UK)
2. Select a product status drop down list (let's say only Active products)
3. Select a specific period for sales drop down list (let's say Jan-2004 to July-2004)
the form has to perform the following tasks:
1. Give all the CustomerNumber & Customer Numbers in Germany
2. Give all Active products being sold to those customers
3. Given the period specified.....
Is it possible? In a Query it would be possible. But I want use the "fancy" drop down list. (For oracle people, Just like Oracle Report Request).
If it is possible, how do I have to approach it?....VB?...
Any suggestions would be welcome,
tnx,
Zurvy