Access Novice in the true sense of the word

[AccessDummy99]

Hi
I have this result from a query. If the sale date and the receipt date are
the same I don't want to bring them through in my query. Easy to do in excel
not so easy in access. So I want to see Cust 2 but not Cust 1. Any
suggestions?

Cust Invoice# Amount Emp Sale Date Rcpt Date
Cust 1 X1 80.00 Employee 1 10-Jul-08 10-Jul-08
Cust 2 X2 60.00 Employee 2 11-Jul-08 21-Jul-08

 

[bcap]

In the query design window, locate the column in the grid which is headed by
"Sale Date". Below this, in the *row* headed "Criteria", enter the
following:

<> [Rcpt Date]

 

[AccessDummy99]

I knew it would be something simple like that, thank you!
--
AccessDummy99

In the query design window, locate the column in the grid which is headed by
"Sale Date". Below this, in the *row* headed "Criteria", enter the
following:

<> [Rcpt Date]

Hi
I have this result from a query. If the sale date and the receipt date
are
the same I don't want to bring them through in my query. Easy to do in
excel
not so easy in access. So I want to see Cust 2 but not Cust 1. Any
suggestions?

Cust Invoice# Amount Emp Sale Date Rcpt Date
Cust 1 X1 80.00 Employee 1 10-Jul-08 10-Jul-08
Cust 2 X2 60.00 Employee 2 11-Jul-08 21-Jul-08

 

[Steve]

Put the following criteria in the Sale Date fild in your query:
<> [Rcpt Date]

Steve