Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Statement
- Thread starter ITA
- Start date
VBA code<br>
Dim db as database, rst as recordset, SQL as string<br>
Set db = CurrentDb<br>
' SQL string.<br>
SQL = "SELECT * FROM Orders WHERE OrderDate >= #1-1-95#;"<br>
Set rst = db.OpenRecordset(SQL)<br>
debug.print rst.fields("Orderdate")<br>
-----<br>
OR <br>
in the queries TAB<br>
<br>
SELECT Distributors.CUSTNUM, Distributors.COMPANY, Distributors.ADDRESS, Distributors.ZIP<br>
FROM Distributors;<br>
<br>
<br>
Dim db as database, rst as recordset, SQL as string<br>
Set db = CurrentDb<br>
' SQL string.<br>
SQL = "SELECT * FROM Orders WHERE OrderDate >= #1-1-95#;"<br>
Set rst = db.OpenRecordset(SQL)<br>
debug.print rst.fields("Orderdate")<br>
-----<br>
OR <br>
in the queries TAB<br>
<br>
SELECT Distributors.CUSTNUM, Distributors.COMPANY, Distributors.ADDRESS, Distributors.ZIP<br>
FROM Distributors;<br>
<br>
<br>
- Thread starter
- #4
I have used a logical operator to solve my problem. Basically I was using a table to list names, and I wanted to pull all the names for a particular report. I also wanted to leave out one name from the table. Below is what I used on the SQL statement:<br>
<br>
<>name<br>
<br>
Thanks
<br>
<>name<br>
<br>
Thanks
- Status
Similar threads
- Locked
- Question
