RE: How do I exclude displaying fields that do not meet a query
- From: jl5000 <jl5000@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 6 May 2005 18:04:02 -0700
Under each date field in your query criteria copy the same condition like
Field: Date1 Date2
Table: MyTable MyTable
Criteria:between [Initial_Date] and [Final_Date] between [Initial_Date]
and [Final_Date]
an so on for all 8
--
jl5000
<a href="http://joshdev.com";></a>
"Quickpath" wrote:
> I have a new database that I created that has 8 date fields for each record,
> along with other fileds for name, address, etc.. I created a query that will
> search for dates that are within a 30 day range of today's date. This query
> then creates a report that shows these dates along with other fields (name,
> address, etc.)
>
> My questions is this: how do I modify the query so that only those specific
> date fields that meet my search critera will show up on the report. As it is
> now, if any date in each record meets the critera, then all the date fields
> show up on the report. Thanks.
.
- Follow-Ups:
- RE: How do I exclude displaying fields that do not meet a query
- From: Quickpath
- RE: How do I exclude displaying fields that do not meet a query
- References:
- How do I exclude displaying fields that do not meet a query
- From: Quickpath
- How do I exclude displaying fields that do not meet a query
- Prev by Date: RE: Multi Lined Output
- Next by Date: unique records
- Previous by thread: How do I exclude displaying fields that do not meet a query
- Next by thread: RE: How do I exclude displaying fields that do not meet a query
- Index(es):
Relevant Pages
|
