|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 7th, 2004, 12:01 PM
|
|||
|
|||
select records by blank criteria
Access 2000
I wish to select records in an access select query that (1) have no data in the criteria field (2) includes all records that do not are not blank 
|
|
#2
October 7th, 2004, 02:10 PM
|
|||
|
|||
|
hi,
not sure what you mean here. a blank record is not a record and should not be selected. Do you mean not containing blank fields.? if so then you will have to use criterial. IS NULL or IS NULL -----Original Message----- Access 2000 I wish to select records in an access select query that (1) have no data in the criteria field (2) includes all records that do not are not blank .
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| The 'Select' query sometime does not return all the records with . | Sanjay Kumar Limbikai | Running & Setting Up Queries | 2 | October 3rd, 2004 07:15 AM |
| Pulling Select Random Records in Access Query | JLopez | Running & Setting Up Queries | 0 | September 13th, 2004 07:27 PM |
| Select Distinct Records | Les Coover | Running & Setting Up Queries | 2 | September 9th, 2004 12:25 AM |
| Showing all records when criteria not chosen | Deb Smith | Using Forms | 1 | August 8th, 2004 09:33 PM |
| Create a new temp table and populate with n blank records | Gareth Mercer | Database Design | 3 | May 19th, 2004 01:38 PM |
Linear Mode
