Lab Sql

I'm using this query to get some specific data: 'select * from emp where emp_name LIKE '… Read more How To Use Like Condition In Sql With Numeric Field?

I have a VB6/Access application that occasionally encounters a problem with wrong autonumber field … Read more Reset Autonumber Seed

Is there an equivalent for Oracle's decode() in Access (or Jet, for that matter). The problem I… Read more Access/jet Equivalent Of Oracle's Decode

Summary: Using the Jet.OLEDB provider and the SQL query, I do not know how to access the column the… Read more How To Select [header Text W. Dot] As Xxx From An Excel Table?

I have a stock table and I would like to create a report that will show how often were items ordere… Read more How To Combine Two Sql Queries?

I have a VB6/Access application that occasionally encounters a problem with wrong autonumber field … Read more Reset Autonumber Seed