d look up

I need some help with this
I have a table with 6 columns
If my Date Ticket Purchased is between this date and this date then LC
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14055-d-look-up.html
This is what my table looks like

ID LC CC FY FY Start Date FY End Date
1 06060130 6216407 06 7/1/2005 6/30/2006
2 06070130 6216407 07 7/1/2006 6/30/2007
3 06080130 6216407 08 7/1/2007 6/30/2008
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14055

So if the date ticket purchased fall between any of these dates then I want
for example the proper LC to show.
I need to do this for LC CC and FY
Once I get the first one I think I can do the rest.

Thanks so much

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!