Search results

Where am i wrong in this formula. I am not getting the exact results. Expr1: [Total C]+Nz([Final Export]![Company Provided Social & Healthy Security],0)+Nz([Final Export]![Employers Additional Charges (Above 20%)],0)*[ExchRate]+Nz([Mobilization Demobilization Cost]+Nz([Final Export]![Furniture...

Hi .. Where am i wrong in this formula. I am not getting the exact results. Expr1: [Total C]+Nz([Final Export]![Company Provided Social & Healthy Security],0)+Nz([Final Export]![Employers Additional Charges (Above 20%)],0)*[ExchRate]+Nz([Mobilization Demobilization Cost]+Nz([Final...

Thanks Arnel! As you know i am not proficient in programming! Could you please try to see and fix the original query in the attached file if possible

Hi Experts! I am trying to do some sum of percentages through my cross tab query and couldn't get through:banghead: Could anyone help me to resolve it. Please look into my screen shots. 1. in the first picture you may see the query. 2. is the result of that query. 3. is the one I need...

Thanks a lot Arnel! Are you working here in Qatar? if so please let me know your contact details. I have a small project to do. I can pay you for this too.

Thanks Guys!

Hi Stopher, I tried to change the relationships as you suggested. but still the delete button deletes data in the subform one by one and project number is not deleted from the project master table. Well, "Main Table" stores all data selected from the Project Master Table and other related...

:banghead: Dear Experts: I am a beginner in MS Access. Well I have developed a small software and now my issue is as follows: I am not able to delete all related records in a subform and the form when clicking the delete option. When i am clicking it should delete the project number and...

Thanks a Million Arnel!!! You made my day! :-) God Bless!

Oh ok it's fine. However I have two other concerns : - Column headers are not displaying and - Values are not appearing in the report. Could you kindly look into it and let me know the wrong things from my end! God Bless!

Dear Arnel, Thanks for your quick response. But still i am getting the same error message while click on preview button. Could you please look into it again if possible! :)

Hi Dear Arnel, Could you please look into this matter if possible. Thanks! http://www.access-programmers.co.uk/forums/showthread.php?t=285803

:banghead: Hi.. Am just a beginner in Access. Trying to do a Cross Tab Query Dynamic Report as you can see in the attachment. I tried with a sample coding got from another website and tried to adapt the same in my crosstab query. But I have few issues: 1. When I am running the report from the...

Thanks a lot!!!:D Thanks Marlan! It is fine now!! I used <>IIf([Location]="0217","075","")

Couldnt get through the suggestions!:rolleyes:

Dear Marlan, Plz find attached my database. When you run query1 input 0217 and the result will be blank and if you try 0221 you can see all data including "075" (Empno). Actually what i need is to exclude Empno ("075") from table1 entries when i input 0217 as project number and should see all...

Whats wrong with this code: Can any one solve this please: ((Table1.Location)=[Enter Project Number]) AND ((Table1.EmployeeID)=IIf([Location]="0217",[Table1].[EmployeeID],[Table1].[EmployeeID]) And (Table1.EmployeeID)<>287 And (Table1.EmployeeID)<>183 And (Table1.EmployeeID)<>264)); Its not...

Try Connection using pivot table external connection : See the pic

Hi Rain, Its in a Report Query.

Hi..Rain, Do you have some advises in this regards. Plz help me.:(