Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select latest data available and info for the previous year

Status
Not open for further replies.
douggy

douggy

Technical User
Jan 18, 2001
78
GB
I have two tables:

1) ORGANISATION
2) FINANCE

The basic join query outputs the following:

Key|Organisation |Renewal_Date |Fee |Paid_Date |

001|Mark Ltd |17/09/2001 | |
001|Mark Ltd |17/09/2000 |5000 |15/09/2000|

One company can have many financial years of payment information.

I need to select the next renewal date and select payment information for the immediate previous year available.

This all needs to be returned on one line.

From above I would therefore output:

Key|Organisation |Renewal_Date |Fee |Paid_Date |
001|Mark Ltd |17/09/2001 |5000 |15/09/2000|

Can anyone help.

Cheers
Mark
 
Status
Not open for further replies.

Similar threads

datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
597
dhookom
dhookom
spartansFC
  • Locked
  • Question
Display Year between 2 dates 1
Replies
1
Views
556
dhookom
dhookom
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
3K
lameid
lameid
monkeysee
  • Locked
  • Question
Select Query for append query 1
Replies
12
Views
393
monkeysee
monkeysee
Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
620
Swi
Swi

Part and Inventory Search

Sponsor

Back
Top