Search results for query: *

I have to tables. The first (A) table contain EmployeeNo, EmployeeFirstName, EmployeeLastName, EmployeeNationalty. The second table (B) with same fields but with deffernt values. Now I want to update the first table and take all values from Table B to Table A with keep old information in Table...

Thank you But if the employee work 7 years. Your code will use the second rule for all 7 years. To be perfect, The Formula should calculate first 5 years with first rule and tow years with the second rule. thx

HI, I have table contain field for date of join. And I want put formula field calculate service period for all employees. The date in this format YYYY-MM-DD the equation is: First 5 year : --------------------------------------- (No.of days/30) * 1.25 * (salary/30)...

Mr. lbass Yes !! It work now !! Thank you Mr. lbass. And Thank you Mr. dgillz .

Mr. dgillz Thanks, But this not solve my problem :( I tried but I can not :( Please I will try show to u my report:(Complete) DEST# FROM TO DEST VALUE K/M The problem here , I want put the City_name in tow fields ( FROM TO ) and i want link this field with Dest_from ...

sorry I try but i don't understand,, Sir, Note: my report is FROM TO PARIS LONDON like that.

8.5

I have 2 Tables : City: City_ID City_name Dest: Dest_ID Dest_city_from Dest_city_to Now, I Insert this tables to the report, And I make link between this tables as: City_ID= Dest_from Now , The report show All start cities ( FROM ) , But I need to insert SQL Expression to show End Cities (...

chrissie1 Thank you. It work now ;)

tman72 i wrote here because i can not find the answer.

chrissie1 No.

Easy Question about Data Set Hi,, This code show first row from Data Set in The Text Box no 16: TextBox16.DataBindings.Add("Text", dataSet2, "GatePass.type_name") I want code show second or third row in The Data Set.

Please help me

Hi,, I defined TTT as new DataGridViewComboBoxColumn and connect it to Data Base. TTT shows values. And I defined variable XXX as string. Now I want when user chose value from TTT. XXX is assigned to this value. How can i put in XXX this value? Because I try use this code: XXX= TTT.Text but...

It work now. Thank you man :)) if you have time... can you explain me how this code work?

New problem !! now when i try run the report. The Report show this message: a string can be at most 254 characters long. note: I insert one employee as parameter. and when I remove the suppress from details line. The employee no print 20 times.

Madawc lbass Thank you. It work now :))

Madawc I did first step. But I can not write the code. Please see: whileprintingrecords; if not isnull({Qualifications.Description}) and {Qualifications.Description} <> " " then stringvar pst := pst + {Qualifications.Description} +", " else if length(pst) = 0 then stringvar pst := pst +...

Hi,, I create report as form. The Report contain this rows: Employee No: Employee Name: Employee grade: Employee Job Title: Employee Qualifications: Ok? Let Toni has tow qualifications. And we want print this report: Employee No: 123 Employee Name: Toni Employee grade: 7 Employee Job Title...

Mr. JohnOB Thank you. Yes that's right.