need some queries

[halil]

hi there
im makin a stock control databse , and i need some suggestions on some queries that i can use

thx in advance

 

[Fornatian]

start with functionality - what you need to do will define what queries you need?

 

[halil]

the system will keep tracks of stock , once a item is sold the stock level decreses ( does a query need to be made to do this if so how ) and it should search for items, suppliler names, manufacture name etc

thx in advance

 

[Fornatian]

You are still being very vague - start with "I need to..."

"I need to be able to see all sales of a certain good between defined periods"
"I need to be able to see my income on a monthly basis"

For examples of queries see the Northwind and Solutions databases that come with Access.

 

[halil]

"I need to be able to see all sales of a certain good between defined periods"

cud u tell me how to do the qury for thi splz

 

[Fornatian]

You need to do some basic reading up on queries and how they work, although I could show you an SQL example, you will not understand how it works unless you are prepared to put some effort into researching your problem.