Search results

hi all how do this formula? if multiple condition if number less than 2000 ,2000 from 2001 to 3000 -------> result 75% with minimum 2000 and maximum 2250 from 3001 to 4000 -------> result 70% with minimum 2250 and maximum 2800 from 4001 to 5000 -------> result 65 % with minimum 2800 and...

how to calculate sum for the following per each employ if count of days more than 30 than add 1 to month than if month =12 month =0 and add 1 to years EMP EMP SumOfDAYS_NO SumOfMONTH_NO SumOfyears_No final days final month final years A A 32 11 13 2 0 14 B B 37 17 15 7...

Attached Files

hi I have table Categ_Tb ---> category_Id - minimum_Value - Maximum_Value AND Other table Value_Tb Value i need query Query1 LOOKUP this VALUE in minimum_Value - Maximum_Value if it between minimum_Value - Maximum_Value return category_Id

hi I need to make fixed row for report if no data in text report this row show empty if page 1 shown 15 record only and data show in report 13 than the 2 row in report empty as attached example page 1 of report is continue from 18 record i need fixed row in report for all page in...

hi please i need to split number or text like 022588858 to many text in report 0 2 2 5 8 8 8 8 5 8

please any help to convert attached database from 32-bit to 64 bit and remove security ( show all forms )

Equation for Goal Seek on Multiple Cells or any formula do it without VBA SALARY 10,166.67 INUSRANCE 666.67 NET AMOUNT 9500 i need when i add tax salary 1000 i need to re calculated salary again to be net salary 9500 like goal seek but i need it for 10000 employee any ideas for

hi all how make month balance for any selected month beginning month balance ----- end month balance i have data_tb which continue from data for many company with her monthly movements and credit or debit credit it's meaning ( money deserved to our company ) debit --- payments or any...

Hi all i have query have many calculations when i put this formula Tax_Year...

hi all in excel to get round up number like 325 ------ use roundup to do it like 330 how do it in access QUERY iTEM Count A 305 ------.> ROUND UP TO 310 B 209-------. ROUNDUP TO 210

good day for all please help in following In company we have a lot of employee Company make summer resort to many place Like place 1 ,place 2, place 3… And we want to get ranking for each employee depend on many rules If many employee select place1 and group1 I want ranking employees...

hi please help in append sequential numbers in access query or table ( this sequence is variable ) based in number I put it in form like 12500 I want add 500 record sequence like 12501 12502 12503 12504 to 13000 other example 110200000 add 100 Coupon to 110200100 in attached example...

hi please need help to select one of option in form home or work as table designed if I select home work is false and if select work home is false thanks

i have table Reservation_tb which I select gest ,hotel name and select period from date and to date how I get single room rate from rates which in Hotel_RATE_tb which different from date to date I need query to get this rate for ( if gest will stay in hotel three days ) eva from...

hi ay help to do this dlookup value from query sum when inter data in data Query

How to calculate cumulative late per employee during month Query DATA_QRY Filed name Cumltive_Late

i have Movements_during_qry ------ movments to all employee during day Movements_qry------- which including arrival in morning and depature in end day how i combine two query’s in one query to show data example in day 05/02/2015 show employee 1 show all movements and arrival (...

hi, i want to hide external data and databasetools tabs from my access program how i do it ? thanks in advanced for your help