Take a look at your join for the tables.. Usually the default for a
join is when there has to be the same value in each table. You need to
do a left join on the part table so it will include all the records.
Butch
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Susan Iverson
Sent: Wednesday, September 21, 2005 10:14 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Running a Balance on Hand for ALL parts that includes
Dimensional Parts
I'm printing a Balance on Hand report for users to compare during our
physical but have found that whenever I include the dimension tables,
the only parts I get are those with dimensions. Has anyone discovered a
work-around that would save me some time? The physical is on 10/01. A
complete BOH of all parts including dimensions with the codes and
factors.
Sue
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
________________________________
YAHOO! GROUPS LINKS
* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
________________________________
[Non-text portions of this message have been removed]
join is when there has to be the same value in each table. You need to
do a left join on the part table so it will include all the records.
Butch
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Susan Iverson
Sent: Wednesday, September 21, 2005 10:14 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Running a Balance on Hand for ALL parts that includes
Dimensional Parts
I'm printing a Balance on Hand report for users to compare during our
physical but have found that whenever I include the dimension tables,
the only parts I get are those with dimensions. Has anyone discovered a
work-around that would save me some time? The physical is on 10/01. A
complete BOH of all parts including dimensions with the codes and
factors.
Sue
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
________________________________
YAHOO! GROUPS LINKS
* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
________________________________
[Non-text portions of this message have been removed]