Shoutbox

i have an access db with 10 different fields i want to make a number of different queries, but i want to query 7 out of the 10 fields each time and i can't get the query right so does anyone have any ideas?

"SELECT OneThing, AnotherThing, ThirdThing FROM SomeTable"?

code:

---

SELECT Table.ID, Table.SNAME, Table.FNAME, Table.L1
FROM table
WHERE (((Table.L1) Like "text**"));

---

thats what it looks like for one field, and every time i try add Table.L2 i stuff it up somehow

I think you are getting parenthesis-happy there.  I see nothing that calls for use of all those parenthesis.

code:

---

SELECT Table.ID, Table.SNAME, Table.FNAME, Table.L1
FROM table
WHERE Table.L1 Like "text**"

---

...should be perfectly fine.  If you want to add another column to the condition, you could do something like:

code:

---

SELECT Table.ID, Table.SNAME, Table.FNAME, Table.L1
FROM table
WHERE Table.L1 Like "text**" AND Table.L2 <> 2

---

quote:

---

Originally posted by Adeptus
I think you are getting parenthesis-happy there.  I see nothing that calls for use of all those parenthesis.

code:

---

SELECT Table.ID, Table.SNAME, Table.FNAME, Table.L1
FROM table
WHERE Table.L1 Like "text**"

---

...should be perfectly fine.  If you want to add another column to the condition, you could do something like:

code:

---

SELECT Table.ID, Table.SNAME, Table.FNAME, Table.L1
FROM table
WHERE Table.L1 Like "text**" AND Table.L2 <> 2

---

---

that sql was generated by access
using your query i get

quote:

---

Originally posted by access 07
data type mismatch in crirtia expression

---