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
|
|||
|
|||
querie Criteria date range and find records on ProductType
I need a Criteria that gives me a date Range, and in that date range finds
matching ProductType but when I run the querie, if i do not type a ProductType, just type the date range, I want the querie to return all records in that date range, i try under date: Criteria Between [enter begining date] and [enter end date] and under ProductType Criteria Like [enter Product Type] or is null [ enter Product Type] but it does not work because if i don't type a ProductType it returns all Records in the Database not in the date range that I ask for. |
#2
|
|||
|
|||
Use this --
Under date: Criteria Between [Enter begining date] and [Enter end date] Under ProductType Criteria Like [Enter Product Type] & "*" or is null If you press the Enter key without entering a Product Type it will still work. "Rodrigo R via AccessMonster.com" wrote: I need a Criteria that gives me a date Range, and in that date range finds matching ProductType but when I run the querie, if i do not type a ProductType, just type the date range, I want the querie to return all records in that date range, i try under date: Criteria Between [enter begining date] and [enter end date] and under ProductType Criteria Like [enter Product Type] or is null [ enter Product Type] but it does not work because if i don't type a ProductType it returns all Records in the Database not in the date range that I ask for. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Question about using Find with a Range object | Max Moor | Formatting Long Documents | 11 | May 16th, 2005 04:47 PM |
I need a formula to find rows within a date range in one column? | M. Penney | Worksheet Functions | 5 | May 12th, 2005 12:32 AM |
Having trouble with multi-select list box in Access | brandelfly | New Users | 4 | February 10th, 2005 07:36 PM |
QDE (Quick Date Entry) | Norman Harker | Worksheet Functions | 37 | September 5th, 2004 01:24 AM |
QDE (Quick Date Entry) | Norman Harker | General Discussion | 3 | September 3rd, 2004 08:00 AM |