By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,503 Members | 2,788 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,503 IT Pros & Developers. It's quick & easy.

join type help

P: n/a
hey... i have a query with 13 fields from 1 table and i wish to add 3 fields
from a different table to this query. both tables have a [date] field but
the records won't necessarily have the SAME date for each of those two fields.
the date MAY sometimes match up but definately not all of the time. how can
i add these three fields properly?

--
Greg

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200604/1
Apr 14 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
short answer, you can't. The data sets have to intersect somewhere.
Otherwise, how do you know what records are related?

Apr 15 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.