G
Guest
I have a form where you can enter new product names and it is stored in
table1. I then have a query that combines the productname from table1,
product category from table2 and then the retailprice and wholesale price
from table3. However, because the new productname is stored in table1 there
isn't any entries for it in table3 so the new productname is not included in
the query. Is there a way to have the query just show 0 for retail and
wholesale if the productname isn't entered yet? Thanks.
Table 1
Product Name
Table 2
Product Category
Table 2
Product Name ProductCatergory RetailPrice WholesalePrice
a 1
a 2
a 3
b 1
b 2 ......
table1. I then have a query that combines the productname from table1,
product category from table2 and then the retailprice and wholesale price
from table3. However, because the new productname is stored in table1 there
isn't any entries for it in table3 so the new productname is not included in
the query. Is there a way to have the query just show 0 for retail and
wholesale if the productname isn't entered yet? Thanks.
Table 1
Product Name
Table 2
Product Category
Table 2
Product Name ProductCatergory RetailPrice WholesalePrice
a 1
a 2
a 3
b 1
b 2 ......