|
| 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
November 30th, 2006, 05:24 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Quering Fields With Value and Only Those Fields
If you are using the Query builder and only want records with a value in Date
Cancelled, put the following in the Criteria for that field in the query: IS NOT NULL "HLD920" wrote: I need help. I have a table that includes a field for Date Cancelled. I want to create a query where it will only generates the records that include a field that a Date Cancelled entered in it. Can someone please help in how to generate this query. Thanks for your help. 
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
