A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

querie Criteria date range and find records on ProductType



 
 
Thread Tools Display Modes
  #1  
Old August 5th, 2005, 07:43 PM
Rodrigo R via AccessMonster.com
external usenet poster
 
Posts: n/a
Default 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  
Old August 5th, 2005, 11:26 PM
KARL DEWEY
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 04:51 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.