Prev: Locked out Completely
Next: How do I get the date to display a Julian date? (yyddd)
From: Rubem on 4 May 2010 23:10
Hi,

I have a query with the following fields: Date, Part Number, description,
etc...
I am trying to create a query with 2 criteria but independent. In another
words. I want a criteria to give just the data in a data range or just a
list of the part number I want. I would like to have only one query with
this two criteria.

Any suggestion.

Thank you.

Rubem
From: Tom van Stiphout on 5 May 2010 01:30
On Tue, 4 May 2010 20:10:05 -0700, Rubem
<Rubem(a)discussions.microsoft.com> wrote:

"Date" is a reserved word so should not be used as a field name. Let's
change it to PartDate or whatever makes sense.
Create a query in design view, and put the fields on the grid. In the
first criteria row put your date range criteria, and in the next row
down put your partnumber criteria. This creates the "Or" condition you
want.

-Tom.
Microsoft Access MVP


>Hi,
>
>I have a query with the following fields: Date, Part Number, description,
>etc...
>I am trying to create a query with 2 criteria but independent. In another
>words. I want a criteria to give just the data in a data range or just a
>list of the part number I want. I would like to have only one query with
>this two criteria.
>
>Any suggestion.
>
>Thank you.
>
>Rubem
From: Rubem on 5 May 2010 10:15
Tom,

Thank you. Work as I wanted.

Rubem

"Tom van Stiphout" wrote:

> On Tue, 4 May 2010 20:10:05 -0700, Rubem
> <Rubem(a)discussions.microsoft.com> wrote:
>
> "Date" is a reserved word so should not be used as a field name. Let's
> change it to PartDate or whatever makes sense.
> Create a query in design view, and put the fields on the grid. In the
> first criteria row put your date range criteria, and in the next row
> down put your partnumber criteria. This creates the "Or" condition you
> want.
>
> -Tom.
> Microsoft Access MVP
>
>
> >Hi,
> >
> >I have a query with the following fields: Date, Part Number, description,
> >etc...
> >I am trying to create a query with 2 criteria but independent. In another
> >words. I want a criteria to give just the data in a data range or just a
> >list of the part number I want. I would like to have only one query with
> >this two criteria.
> >
> >Any suggestion.
> >
> >Thank you.
> >
> >Rubem
> .
>
 | 
Pages: 1
Prev: Locked out Completely
Next: How do I get the date to display a Julian date? (yyddd)