sql problem

  • Thread starter Thread starter resonance
  • Start date Start date
R

resonance

Hello, I have a "results table" in access database like following:

results
----------------------
lab id
--- ---
12 1
12 2
12 6
13 1
13 3


I need all "id" of lab 12 for example. I have written a sql statement but it
does not return anythig.
SELECT id FROM results WHERE lab=12

How can I choose all "id" of a certain lab?
 
Hello, I have a "results table" in access database like following:

results
----------------------
lab id
--- ---
12 1
12 2
12 6
13 1
13 3


I need all "id" of lab 12 for example. I have written a sql statement but it
does not return anythig.
SELECT id FROM results WHERE lab=12

How can I choose all "id" of a certain lab?
Click to expand...

Your SQL is correct as the problem is presented.

I suspect that there is something relevant that
you are not presenting.

Arne
 
Hello, I have a "results table" in access database like following:

results
----------------------
lab    id
---    ---
12     1
12     2
12     6
13     1
13     3

I need all "id" of lab 12 for example. I have written a sql statement butit
does not return anythig.
SELECT id FROM results WHERE lab=12

How can I choose all "id" of a certain lab?
Click to expand...


Try using:
SELECT [id] FROM results WHERE lab=12
 
I have solved my problem, thank you...

Everest said:
Hello, I have a "results table" in access database like following:

results
----------------------
lab id
--- ---
12 1
12 2
12 6
13 1
13 3

I need all "id" of lab 12 for example. I have written a sql statement but it
does not return anythig.
SELECT id FROM results WHERE lab=12

How can I choose all "id" of a certain lab?
Click to expand...


Try using:
SELECT [id] FROM results WHERE lab=12
.
Click to expand...
 
Back
Top