hi,
I have just created a database for handling stock and clients.
I am trying to create a query that will retrieve all stock in the database with the field value "available stock".
Could someone please help im rubbish with queries!!
hi,
I have just created a database for handling stock and clients.
I am trying to create a query that will retrieve all stock in the database with the field value "available stock".
Could someone please help im rubbish with queries!!
Create a query in design view and add the stock table. Add the fields you want in the query including the fieild which contains the value "available stock". Below this field put "available stock" for the criteria.