Home > IT Answers > Microsoft Windows > MS Access query
kgonzales
20 pts.
 MS Access query
Microsoft Access 2003, Microsoft Access database
I have a large table for a leasing database, and it includes a column for start dates and end dates of lease terms, and there are up to 11 lease terms. I am trying to write a query that will identify the current lease term, and then another query to identify the current rent rate based on which term is current. I am not having any luck finding references to this type of query. I am thinking I might need to restructure my table, but again, not sure how. Any suggestions?

Software/Hardware used:
Access 2003
ASKED: September 7, 2012  6:33 PM
UPDATED: September 7, 2012  6:55 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Some example data, and a clear specification of your current table structure would be helpful.

carlosdl
 63,535 pts.