Search results

Hi Guys, Please help me to run this query. I have Two Tables : Table_01 Employee_Number Employee_Name Table_02 Employee_Number Employee_Name My table_02, contains updated name of the customer in Arabic, and I want to update the Table_01 Employee Name with Table_02. I have hundred records...

Main functions of this database is for Simple Project Management, I Have 3 Tables, Project,Variation and Billing Table. These two tables are one to many relationship. Project to Many Variation. Project and Variation Record has its own PO Number. Now I've created a bill form which...

hi.. i need help with one of my tables. tbl_type1 -type1_id -PONumber tbl_type2 -type2_id -PONumber tbl_bill -billID -PONumber -bill_type Now I have huge data from tbl_bill which contains mix PONumber depends on type. If bill_type is type1 then it will get data from tbl_type1 table and...

Hi! I have 3 tables, tbl_type1 -ID -PO_NO tbl_type2 -ID -PO_NO tbl_bill -ID -PO_NO -Type I have a combo-box that if i change the to type1 it will copy the PO_NO from tbl_type1, or vise versa. now my problem is i have a lot of records in tbl_bill, and those 2 table_type is changing, so i don't...

UP :) same problem here :( I need to update a recordset, because my table1 copying data from table2, and i need run an update for all record. so any changes from table2 will reflect to table 1. please help :) thanks! :)

wow! It works! :) thanks so much! :)

Hi.. i'm trying to filter from dsum criteria the two values, here is my code : =DSum("Amount","qry_sumawpo","[Status] = 'FBLNG'" OR "[Status] = 'BLLD'") please help me to correct this code. I need 2 different values in 1 criteria.

hi! i have a form for our reference number and we need to add prefix according to the type of letter. here is the sample : gitnangsilangan.com/eyeseven/form.jpg for example i choose the "letter" in my type field, the the letter "L" will be added to the auto number field (EDSCO/1147/L). and if...