Lookup with table

[Guest]

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.

 

[Douglas J. Steele]

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