Group,
I have a query that is returning the correct results I am looking for.
However, when I export the data from that same query it is returning
extra rows/records that I do not want. I can't figure out why when I
export the query it is bringing in additional records when my query
itself is returning the correct results. Below is the FROM and WHERE
clause.
FROM (er RIGHT JOIN wia_app ON er.er_num = wia_app.er_num) LEFT JOIN
wia_case ON wia_app.wia_app_num = wia_case.wia_app_num
WHERE (((wia_app.wia_agcy_cd)="oic")) OR
(((wia_case.wia_agcy_cd)="oic"));
The last part of the WHERE clause wia_case.wia_agcy_cd is not shown in
my result set, but it is only there as a condition. I have it hidden
from the result set.
Any ideas why this is happening with my export results set?
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ms_access/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
