Select the specific data from database.

[veasna]

In table "Product" i want to write a query to select data from field "Item" where the value of field "Item" equal to "Gin".

I am a fresh in Ms Access. Could you tell me to write the code to solve this problem?
Thanks,

 

[ajetrumpet]

In table "Product" i want to write a query to select data from field "Item" where the value of field "Item" equal to "Gin".

I am a fresh in Ms Access. Could you tell me to write the code to solve this problem?
Thanks,

SELECT [item] from product

WHERE [item] = "gin";

read up on SQL. this is the simplest of queries in any database setting.

 

[veasna]

Could you please give me the full VBA code in Access to do with this?

 

[jdraw]

Could you please give me the full VBA code in Access to do with this?

There are tutorials at this site dealing with SQL and VBA
http://www.fontstuff.com/access/acctut15.htm