|
View Full Version : Some record not showing on query.something wrong? romanticode 10-27-2007, 12:13 AM I have make relational table on query, but some record not sohowing on query, although i have the record on table. for example, i can't see the record with code : 131401.007 541000.00* is the anything wrong? thanks ajetrumpet 10-27-2007, 05:51 AM Yep, the record marked with the asterik is not in the table. Rabbie 10-27-2007, 06:22 AM I have make relational table on query, but some record not sohowing on query, although i have the record on table. for example, i can't see the record with code : 131401.007 541000.00* is the anything wrong? thanks record 131401.007 is showing in query when I run it. No records like 541000.00* could be found in table STOK Plk so because records have to be in all 6 tables to show in query results the query is working correctly. romanticode 10-27-2007, 05:21 PM No records like 541000.00* could be found in table STOK Plk so because records have to be in all 6 tables to show in query results the query is working correctly. I see that some records that's found on one, and not on all of the 4 STOK table, can be showed. foun record show the amount (xx), not foun record show 0. I just want to campare the 4 STOK table, so i need to show all in he 4 STOK table, using SKU table as identification of Item. How can i do that? thanks |