Search results for query: *

I did a simple test by just selection few fields from the tables and it works out alright. Then i try to join them, it just kinda freeze. No sure if that is the problem. I am trying to do BillOfMaterial repot. here is a copy of my query code. SELECT BMPRDSTR.PARENT_ITEM_NO AS Level1Parent...

i am using pervasive database. first i imported the tables to test my query and it worked out ok. But now i want to use link table instead to have the updated data. so i delete the imported table and create a link table with the same name, but it is not showing anything now in the query. please...

Thx Dan i got the idea. i tryied it and it does work. but the problem is that i am not suppose to make any changes in the table. i am using pervasive and i just pulling out data to create the long long BOM report, so i cant go change them one by one. is there a way to solve this issue? kelvin

oh i here is my query, i am trying to do a bom report. SELECT BMPRDSTR.PARENT_ITEM_NO AS Level1Parent, BMPRDSTR.COMPONENT_ITEM_NO AS Level1Component, BMPRDSTR.QTY_PER_PARENT AS Level1QTY_PER_PARENT, BMPRDSTR.SEQUENCE_NO AS Level1SEQ, BMPRDSTR_1.PARENT_ITEM_NO AS Level2Parent...

i am using pervasive database. first i imported the tables to test my query and it worked out ok. But now i want to use link table instead to have the updated data. so i delete the imported table and create a link table with the same name, but it is not showing anything now in the query. please...

The item numbers show up ok in the report. After exporting to excel, some numbers in the excel become strange numbers. everything else is fine. example, in report: 01-0000004-01 01-0000005-01 in excel: 36895 36896 i had checked the fields in table. they are all text. plz help me find...

appreciate your help cosmo. i didnt know that using linking table can connect to ODBC. It should be working now. thanks for the help.

I imported the tables from the database. Is there anyway that i dont have to re-import tables manualy or create a marco to do this action?

i have a ODBC connected to Pervasive database. I created some reports that retrieved data from the database. I dont know if it is possible to refresh the report as the data changed in database, and how?

Thx for replying my question. I have get the idea of recursing through the table, so i try this dumb way. I created several queries with the parent and child. The parent in the 2nd query was chose from the child in the 1st query and so on. All of these went ok, but when i tried to display in the...

All the components are in just one table with ParentID and ComponentID. I could only print up to one level.

I want to create a access report that can support bill of material, print out muti-levels. I have seen some articals about it on internet, but I am a biginner in constructing queries by sql or subroutine in VB. Can someone help me get started or is there other way to create the report?

I want to create a report that can support bill of material, print out mutiple levels. I have seen some articals about it on internet, but I am a biginner in constructing queries by sql or subroutine in VB. Can someone help me get started or is there other way to create the report?

I want to create a report that can support bill of material, print out mutiple levels. I have seen some articals about it on internet, but I am a biginner in constructing queries by sql or subroutine in VB. Can someone help me get started or is there other way to create the report?