Query from more than one table


G

Guest

Hey all,
I am building a DB (ACC2003) for an apartment complex with 206 apts. What
they are wanting to accomplish is to have all the data visible in a form.
Here is the problem. I have lease expiration dates for the apts. I wrote a
query to bring these down to 12 totals, (CountofMonth.) What they require is
visibility of these to see how many expirations they have each month and then
compare these to a "Target" mumber and a "Max" number, which are set numbers.
As they approach the target they want to change the text color of the month
from green to orange and as they approach the max they want to change the
color to red. Changing the color I can do, but I cannot figure out how to
combine the info into one query so I can pull it up on one form, side by
side. I need to pull info from 2 tables:

table1
AptNumber
LeaseExpDt
Month (MMM)
(206 rows)

Table2
Month (MMM) these are set to align with the next 2
Target
Max
(12 rows)

Actual is derived from a query:
qryActuals
Month
Countof Month>>gives me actuals
LeaseExpDt>>for sort order

How can I combine these to use them together on one form/datasheet?
One of the problems in trying to tie these two together is that the Month
fields are not the same. One is derived and one is manually entered. That
may be my major conundrum, but I am not sure how to rectify it. Somehow they
need to "see" only the MMM, not the actual short date behind it.

Thoughts??
Thanks!
 
Ad

Advertisements

G

Guest

I am sorry about the repost. There is a glitch in the system somewhere. I
typed in my entire subject and could not find it yesterday. Finally, I
reposted. This morning, I could not find my repost. I found them both by
going to all new posts instead of search.
I still need a miracle here. Somehow, I need to get a common field in these
two tables. The date is the most likely, but I am not sure how to do it.
One table uses full dates and the other uses just months so that no matter
what year the target and the max are consistent to the month. How can I
define a relationship between these two tables so that I can create one query
to use months, actual, target and max in side by side columns?
Please help!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top