SQL Statement

ITA · Dec 13, 1999

I am trying to find the correct syntax to use in a SQL statement that will draw information from a table but omit certian records based on a field. I am hoping that someone will be able to help me with the correct sql statement.

DougP · Dec 13, 1999

VBA code 
Dim db as database, rst as recordset, SQL as string 
Set db = CurrentDb 
' SQL string. 
SQL = "SELECT * FROM Orders WHERE OrderDate >= #1-1-95#;" 
Set rst = db.OpenRecordset(SQL) 
debug.print rst.fields("Orderdate") 
----- 
OR 
in the queries TAB 
 
SELECT Distributors.CUSTNUM, Distributors.COMPANY, Distributors.ADDRESS, Distributors.ZIP 
FROM Distributors;

DougP · Dec 14, 1999

I'm no sure I answered your question above. 
Give us some idea of where the data is coming from. 
tables, forms, calculations and I can create an example.

ITA · Dec 14, 1999

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: 
 
<>name 
 
Thanks

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!

SQL Statement

ITA

Programmer

DougP

MIS

DougP

MIS

ITA

Programmer

Similar threads

Part and Inventory Search

Sponsor