Search results

Hi Freinds, Can anyone please tell me that how can I use IIF function in my query? Thanks mithani

Hi Freinds, Can anyone please tell me that how can I use IIF function in my query? Thanks mithani

Hi fibayne, could you please upload your report? mithani

thanks guys regards mithani

Hi mates, I want to creat menu. That should be similar to any microsoft product, like File, Edit, View, etc. I would appreciate if anyone got any sample. I tried to design but seems I am very poor with menu designing. Thanks mithani

Thanks Missingling, Sorry man I was sick so couldn't see your reply. I couldn't find acDialog option. Few options are there: acDesign, acFormDS, acLayout, acNormal & acPreview. thanks mithani

Thanks GolferyGuy, I did popup and modal properties YES but still reports run immediately after open "Remarks" form. What could be the reason? any Clue. Thanks mithani

Thanks GolferyGuy, I did popup and modal properties YES but still reports run immediately after open "Remarks" form. What could be the reason? any Clue. Thanks mithani

Hi friends, I have got print button in my form. What I am doing is: DoCmd.OpenForm "remarks", acNormal DoCmd.OpenReport "Ac-report", acViewPreview, When I click my print button, form "Remarks" popups and immediately my report runs. How can I fix that when I close my "Remarks" form...

Friends, Is it possible while making my report, I can restrict in my total not to calculate(quantity * rate) when "expenses_codes" repeats? Appreciate your help mithani

Thanks KeithG, My query is based on two tables, one is purchase and other is just project expenses code. Many purchases transactions can be done in each expenses code. I know I have a problem with table nomalization and my table structure has to be changed but didn't get much time to do that...

KeithG, My query should show all record(even duplicate) but only while doing total (quantity * rate), i don't want to calculate total for repeated code. So i think i have write something in criteria? Please help me. Mithani

Thanks KeithG, Where I have to write this select statement in my query? Thanks mithani

Dear Friends, I have one query based on code, rate, quantity. I created field for total (rate x quantity). What expression i can write that the query will calculate total only with the first figure as per code and if code repeats again, should not calculation total. Please see the following...

Hi Friends, Can anyone help me with my SQL problem. thanks mithani

Thanks ajetrumpet, You are right, project names are distinct. See the attached database. Please run the query. I hope you will get better idea that what exactly I am looking for. Thanks mithani

Dear Mate, Please see the attached excell sheet. Where you can quide me what SQL query has to be written. Three tables are there: 1. Project .... name of projects 2. Purchase .... purchase transaction 3. Project cost .... having project cost code 4. Need Output.... Thats what I am looking...

Thank Pondlife, You must have found that I am not very stronge with SQL. My table 2 "Project cost" having 100 of cost codes. When we setup a new project, we setup our cost codes which we will use in our entire project. My table 1 "project cost Project" is basically the purchase transcation for...

HI All, I have two tables: 1. Project Cost Project 2. Project_cost I want two things: 1. I need all data from Project Cost Project even the field "EXPENSES_CODE" from Project_cost is not availble in Project Cost Project. 2. Only include rows where the joined fields "Project_code" from...

Hi friends, Need you help. Recently I have upgraded my system from access 2003 to 2007. Few of things not really working. I have one form where I drew lines and boxes. Initally lines and boxes are disable but as soon as user enters dimensions for lines and boxes, all get visable and change...