|
| 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. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 14th, 2008, 05:52 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Access Novice in the true sense of the word
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 -- AccessDummy99 
|
|
#2
August 14th, 2008, 08:31 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Access Novice in the true sense of the word
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" wrote in message ... 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 -- AccessDummy99
|
|
#3
August 14th, 2008, 09:21 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Access Novice in the true sense of the word
I knew it would be something simple like that, thank you!
-- AccessDummy99 "bcap" wrote: 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" wrote in message ... 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 -- AccessDummy99
|
|
#4
August 14th, 2008, 03:49 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Access Novice in the true sense of the word
Put the following criteria in the Sale Date fild in your query:
[Rcpt Date] Steve "AccessDummy99" wrote in message ... 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 -- AccessDummy99
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
