|  | query question | | |
| | | golan |  |
|  Posted: Wed Sep 03, 2008 2:37 pm Post subject: query question |  |
hello, i have table contract and table payment i want to find which contract
doesnt pay in month that i defined
thanks
--
golani |
| |
| | | Jerry Whittle | |
| | Posted: Wed Sep 03, 2008 3:35 pm Post subject: RE: query question | |
| |  | |
If I'm understanding both the question and what data is in the tables:
Create a query with the contract table first.
Next add the payment table.
Drag and drop the primary key field from the contract table to the foreign
key field in the payment table (in other words the fields that join the two
tables).
Double click on the line between the two tables until a dialog box shows.
Select the 2nd option. This will create a left join.
Make sure that at least one field from the payment table is in the grid and
put Null (without quotes) in the criteria beneath it.
Run the query and see what it returns.
Next put in criteria for the field that has the month information. You might
have to put something like below in the field to produce the month.
TheMonth: Month([TheDateField])
Then the criteria would be 9 for September. Warning: The Month() function
doesn't care about the year or day. 9 would return September records for all
years.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"golan" wrote:
| Quote: | hello, i have table contract and table payment i want to find which contract
doesnt pay in month that i defined
thanks
--
golani |
|
| |
|
|
