Recent content by leongtay

Hi JHB, Sorry for the late reply as i didnt come online the last few days. Your query works perfect, a friend of mine has also got back to me on a query he written in SQL which also works. But i guess yours is better cos if i add more countries to the <Masterlist> there shouldn't be any...

sorry for the confusion caused. Basically i will need shortcodes pertaining to Korea only (i.e. that means with a count of 1 or more). If there are duplicates involved , then its ok to show as multiple line items if it is technically impossible. The same goes for china, that means, if i select...

Dear experts, I have attached a crosstab query to give a better idea of what i want. As per attached in the database file , there is a crosstab query that i have done. If possible, the only <Shortcodes> that should appear will be AE47611, CB01406 and CB06934. This is done after setting the...

Hi JHB, Many thanks for replying to my posts as i really can't find any idea how to go about it. I am looking to create one query for the 3 points that i have mentioned. The main problem i am facing is point number 3. What i want over here is that, if the shortcode exists in both China and...

Dear Experts, As per attached is a Access Database in which i download the table from an Excel file. I am looking to create a query with certain criteria but did not have any luck recently. In the following paragraphs , i will explain by bullet points to give you guys an idea of what is...

Hi Jzwp22, I have managed to remove the duplicates record already by changing the relationship in my query, called QueryMat.I did it by having two materials table joining to a single manufacture table, with one of the Material table linking by the RM ID whilst the other is linked by the...

Hi Jzwp22, I just realised when i added two new finished goods to the table -materials and table-manufacture and run the query -qrymaterialisting, i got duplicate raw material entries for the same finished good. And i realised that when i add a 3rd finished good to tbl materials and tbl...

Hi Jzwp22, Thanks a lot, have hidden the tables already. I am now inputting some data and testing run to do various reports. Might have some questions later, thanks a lot for your help on this.

Hi jzwp22, Thanks so much for your help in this. I will input my raw data into the database for now and see if there's anything else that i might need. In the meantime, there are 3 tables in the relationship diagram which does not belong to my orginal database. Do i remove those?

Hi jzwp22, I have some problem when i doing a test run on my new relationship that i created. since tblmanufacture link to tblMaterials, i am wondering if my relationship as shown in the attached screen shot is correct. In which from tblmaterials, material code link to MaterialCode(FG) and...

Ok thanks..i might not need a exploded bill of materials list afterall. If worse come to worse, i might be able to just make do with the raw materials needed to make the final products without sub-grouping them into intermediaries products since i just need to know the materials required and...

Dear JZWP22, I posted a reply yesterday but unfortunately it seems the forum did not post it. Anyway, thanks so much for your guidance. There are a few point i'll like to clarify with u. Assuming that a certain product called "XYZ" is produced, this product can either be packed off in...

Dear all, i am in the development phase for a database model to be implemented in Access. As per attached is the diagram showing the paper based model that i have developed. Basically, i am looking to develop a database where the customer service personnels can know what HS code to code...

Hi John, Thanks so much for your reply. I understand where you are coming from now. Maybe you are right the finished product could be very different from the raw materials used. As my company is in manufacturing of specialty chemicals such as different kinds of esters, alkoxylates, blends...

Hi , Yes you are right i am talking about the Harmonized system coding. This is just a rough idea that i got out to assign HS codes to finished goods based on bill of materials. So if a particular product use primarily a certain sort of raw material, i could proably use the same HS code for...