Query Grid with two Criteria

[starke1120]

I need to write a query that has a criteria of two separate fields (one
compared to another, then a seperate one) but I can't figure out how
to do it. Let me first explain the table

id (primary ID)
FirstName (text)
LastName (text)
BadgeIn (text)
BadgeOut (text)
Damaged (yes/no)
What I what to do is check if BadgeIn is equal to Badge Out, if not I
want to retrieve the record. I also want to retrieve the record if
BadgeIn DOES match Badge Out, but only if Damage is true (checked).

So
BadgeIn = BadgeOut , Damaged = False - Skip Record
Badge <BadgeOut , Damaged = False - Retrieve Record
Badge <BadgeOut , Damage = True - Retrieve Record
Badge = BadgeOut, Damage = True - Retrieve record.

Im not sure how to go about this. Im guessing an If Statement but I
have never seend one in a query window. I googled for some examples
but counldnt find any like this.

Thanks,

Dave

[pietlinden]

st********@hotmail.com wrote:

I need to write a query that has a criteria of two separate fields (one
compared to another, then a seperate one) but I can't figure out how
to do it. Let me first explain the table

id (primary ID)
FirstName (text)
LastName (text)
BadgeIn (text)
BadgeOut (text)
Damaged (yes/no)
What I what to do is check if BadgeIn is equal to Badge Out, if not I
want to retrieve the record. I also want to retrieve the record if
BadgeIn DOES match Badge Out, but only if Damage is true (checked).

So
BadgeIn = BadgeOut , Damaged = False - Skip Record
Badge <BadgeOut , Damaged = False - Retrieve Record
Badge <BadgeOut , Damage = True - Retrieve Record
Badge = BadgeOut, Damage = True - Retrieve record.

Im not sure how to go about this. Im guessing an If Statement but I
have never seend one in a query window. I googled for some examples
but counldnt find any like this.

Thanks,

Dave

so what's the problem? just put your criteria on multiple lines. And
leave out the false criteria. They won't help you.

So
BadgeIn<>BadgeOut AND Damaged=False OR
Badge<>BadgeOut AND Damaged=True OR
Badge=BadgeOut AND Damaged=True

actually, since Damaged can only be T/F, you don't need them in the
first two statements.

BadgeIn<>BadgeOut OR
Badge<>BadgeOut OR
Badge=BadgeOut AND Damaged=True

[starke1120]

Do I create an expression in a new column then put this in the
creiteria? I guess that is where I am confused. Im new(er) to access.
pi********@hotmail.com wrote:

st********@hotmail.com wrote:

I need to write a query that has a criteria of two separate fields (one
compared to another, then a seperate one) but I can't figure out how
to do it. Let me first explain the table

id (primary ID)
FirstName (text)
LastName (text)
BadgeIn (text)
BadgeOut (text)
Damaged (yes/no)
What I what to do is check if BadgeIn is equal to Badge Out, if not I
want to retrieve the record. I also want to retrieve the record if
BadgeIn DOES match Badge Out, but only if Damage is true (checked).

So
BadgeIn = BadgeOut , Damaged = False - Skip Record
Badge <BadgeOut , Damaged = False - Retrieve Record
Badge <BadgeOut , Damage = True - Retrieve Record
Badge = BadgeOut, Damage = True - Retrieve record.

Im not sure how to go about this. Im guessing an If Statement but I
have never seend one in a query window. I googled for some examples
but counldnt find any like this.

Thanks,

Dave

so what's the problem? just put your criteria on multiple lines. And
leave out the false criteria. They won't help you.

So
BadgeIn<>BadgeOut AND Damaged=False OR
Badge<>BadgeOut AND Damaged=True OR
Badge=BadgeOut AND Damaged=True

actually, since Damaged can only be T/F, you don't need them in the
first two statements.

BadgeIn<>BadgeOut OR
Badge<>BadgeOut OR
Badge=BadgeOut AND Damaged=True

[starke1120]

You got me on track!..

The way I got it to work was create an expression (new column ) in the
query

Match: [BadgeIn]<>[BadgeOut]
cretiera 0 = match and -1 = no match

then put the numbers in the "or" section of the critera to meet the
examples listed.

Is this the correct way of doing it?

st********@hotmail.com wrote:

Do I create an expression in a new column then put this in the
creiteria? I guess that is where I am confused. Im new(er) to access.
pi********@hotmail.com wrote:

st********@hotmail.com wrote:

I need to write a query that has a criteria of two separate fields (one
compared to another, then a seperate one) but I can't figure out how
to do it. Let me first explain the table
>
id (primary ID)
FirstName (text)
LastName (text)
BadgeIn (text)
BadgeOut (text)
Damaged (yes/no)
>
>
What I what to do is check if BadgeIn is equal to Badge Out, if not I
want to retrieve the record. I also want to retrieve the record if
BadgeIn DOES match Badge Out, but only if Damage is true (checked).
>
So
BadgeIn = BadgeOut , Damaged = False - Skip Record
Badge <BadgeOut , Damaged = False - Retrieve Record
Badge <BadgeOut , Damage = True - Retrieve Record
Badge = BadgeOut, Damage = True - Retrieve record.
>
Im not sure how to go about this. Im guessing an If Statement but I
have never seend one in a query window. I googled for some examples
but counldnt find any like this.
>
Thanks,
>
Dave

so what's the problem? just put your criteria on multiple lines. And
leave out the false criteria. They won't help you.

So
BadgeIn<>BadgeOut AND Damaged=False OR
Badge<>BadgeOut AND Damaged=True OR
Badge=BadgeOut AND Damaged=True

actually, since Damaged can only be T/F, you don't need them in the
first two statements.

BadgeIn<>BadgeOut OR
Badge<>BadgeOut OR
Badge=BadgeOut AND Damaged=True