Dear All
I am a new user in Microsoft Access. And i have one problem involve compare.
I have field such as
Name
Capital
Member
Share
Date

I want to compare by date:
Example: Name: Jonh, Capital : 1000, Member : 20, Share: 100, Date 2011
and Name: Jonh, Capital :1200, Member: 21, Share: 110, Date 2012

If capital Up, Member Up, Share Up, Show i want to display Good, If Capital Down, Member Down, Share Down, I want to display Bad, If Capital Up, Member Down, Share Down, I want to display Fair.

Can any one help me please!
Best Regard