Good evening,

I'm working on a database for a club that I'm in, and I've run into
something that has me all confused. I've read through the help files, and
searched around on google, but no good so far.

Tables:
[UserData] - contains [CAT], [Date_monthly],[Pts_monthly]
[CAPS] - contains [CAT], [Date1],[Date2],[CAP]

I need a query that will show me the data from [Userdata] and then have
another column showing the value for [CAPS].[CAP] if
[UserData].[Date_monthly] is between [CAPS].[Date1] and [CAPS].[Date2].

I was thinking that Dlookup might be my saving grace, but I haven't been
able to get it to work.

Any ideas?

Thanks,
G

G:

In the query you join the tables using CAT.

Default is to show only those records where the 2 CATS are equal.

Now you limit that with your between criterion.

You will not see all the record from Userdata.
You will see only those records the matching CAPS record matches the
critereon you set.

You can force the join to show all Userdata records. Highlight the
line between the 2 tables, right click on the line and choose to show
all Userdata records.

If you still have a problem send me and e-mail and I'll send you a
sample.

Good luck

Ira Solomon


On Tue, 10 May 2005 20:37:22 -0700, "George Vaughn"
<gvaughn (AT) wolf-security (DOT) com> wrote: