Lookup with table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff - 11 Sep 2007 15:56 GMT

Hi,

I am trying to build a query that uses two tables.
Table 1 is just a
Column1 = policy number: 1-10,000
Column2: IssueDate: Between "mm/dd/yyy" between 1980 and 2007

Table2:
Issue Date: same data format as table 1
Charge: Vaires by quarter

What I want is to only input the "Issue Date" in Table 2 on each quarter -
because if I put in every date between 1980 and 2007 this would be really
large. The charge only varies by quarter.
Is there a way to do a lookup table with only dates for each quarter?

Thanks for your help.

Reply to this Message

Douglas J. Steele - 11 Sep 2007 16:18 GMT

Rather than Issue Date, you can strictly put Quarter (a numeric field, not a
date field)

When joining the two tables, you'll have to go into the SQL, and set the ON
clause to something like:

ON DatePart("q", Table1.IssueDate) = Table2.Quarter

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi,
>
[quoted text clipped - 13 lines]
>
> Thanks for your help.

Reply to this Message