Search results

  1. I

    Combine records in a query

    Dear Mr Doc_Man... thanks for your reply. Plz note that my boss will be the only user of these hyperlinks. No other people will use it. So this idea is not workable. Regards irsmalik
  2. I

    Combine records in a query

    First, I don't know how to start new thread. So I just kept my question here. Second, my boss use laptop and he want to keep a copy of all the record in his own custody. We don't use server for this kind of data. Hope any solution will be found. thanks irsmalik
  3. I

    Combine records in a query

    Hello friends In questions topics, I could not find Excel. So I am asking my question here. I know how to create Hyperlink in Excel workbook. But I want to give my data to an other person, hyperlinks will work only if the file/ path should be same. In our company we keep the data of our...
  4. I

    Combine records in a query

    Thanks for reply. I tried... but could not understand / follow the suggestions. I want some query through which I could do my assignment. irsmalk
  5. I

    Combine records in a query

    Hello friends .... Here is a CrossTab Query TRANSFORM Sum(DM1.BG) AS SumOfBG SELECT DM1.Company, DM1.Region, DM1.Territory, Format([TDate],"mmm") AS Period1, Sum(DM1.BG) AS Total FROM DM1 WHERE (((DM1.BG)>0)) GROUP BY DM1.Company, DM1.Region, DM1.Territory, Format([TDate],"mmm") PIVOT...
  6. I

    Combine records in a query

    Re: Multi-Select Listbox as filter for Query field Hello Friends For me, it it a difficult question but hope there will be an easy solution. From query, I am getting details of Farmers meetings data i.e. Company Region Territory DTP TDate Periods Here is the query: SELECT DM.CName...
  7. I

    Combine records in a query

    Re: Multi-Select Listbox as filter for Query field Sir Pbaldy... thanks for your reply... I already mentioned that Checkbox is in my Subform.... Now I pasted below line in AddNew Button. CurrentDb.Execute "UPDATE TableName SET FieldName = False", dbFailOnError it is working.... and it clear...
  8. I

    Combine records in a query

    Re: Multi-Select Listbox as filter for Query field Sir Pbaldy... thanks for your reply... I am not using any query.... In my Subform.... I am selecting required records direct from Table. Now how to un-check it. ?
  9. I

    Combine records in a query

    Hello Friends I have to create a Transmittal to send some drawings to our Subcontractor. Now what I do.... when I press AddNew Button, it work like this.... Main form open with fields..... User.... = by selecting from combo box Today's Date = Automatically toddays Receiving Department = By...
  10. I

    Hello Friends I have to create a Transmittal to send some drawings to our Subcontractor. Now...

    Hello Friends I have to create a Transmittal to send some drawings to our Subcontractor. Now what I do.... when I press AddNew Button, it work like this.... Main form open with fields..... User.... = by selecting from combo box Today's Date = Automatically toddays Receiving Department = By...
  11. I

    Multi-Select Listbox as filter for Query field

    Sir Pbaldy......... Thanks a Lot. You Are Great........ You Are Really Great.... Superman.... You wouldn't believe how much tried I have made to remove this error... But always failed..... Sir once again I am thankful to you and hoping for guidance in future. irsmalik
  12. I

    Multi-Select Listbox as filter for Query field

    May be I could not describe my problem.... kindly see the attached database and please run the form and select dates which will be displayed on Screen but will not print on paper and gives error.... #Names. thanks irsmalik
  13. I

    Multi-Select Listbox as filter for Query field

    Month & Date is not printing on Report Hello Friends I am selecting dates from a FORM to print my required data on report. My required data is displaying on Screen.. with the selected Dates... but when I print the report Report , it gives me error.... #Name? This report has of 2 parts...
  14. I

    Multi-Select Listbox as filter for Query field

    Prints Months Name in Brackets with Comma Hello Friends, One more problem to solve and I need your help. I have a crosstab query is below that runs and give me my results. TRANSFORM Sum(qBG.SumOfBG) AS SumOfSumOfBG SELECT qBG.Company, qBG.Region, qBG.Territory, Sum(qBG.SumOfBG) AS [Total Of...
  15. I

    Update query - calcualte a percentage input by user?

    Dear Mr Mark Thanks for the code... but is this complete code.... ? I think last part of the code is missing.... can you plz write the complete code... thanks irsmalik
  16. I

    Update query - calcualte a percentage input by user?

    Dear Mr Mark... I have just tried your idea... its working fine as per my requirement. thanks for your help.... but I will request again regarding your second option of Single date... Thanks irsmalik
  17. I

    Update query - calcualte a percentage input by user?

    Dear Mr Mark Thanks for your reply... yes this is a good idea and a better solution of my problem. I will appreciate if you also explain your second option of One Date.... can you plz explain it. thanks irsmalik
  18. I

    Update query - calcualte a percentage input by user?

    Yes.. Mr arnelgp.... Query Data is not problem. It is fine. Basically I want to print in Report Title / Description "16 July to 15 Aug" and it will go on for further period. At present, I do it manual... but when the user will run this report, he will not be allowed to go into Design...
  19. I

    Update query - calcualte a percentage input by user?

    Here is my query: which run behind my report. SELECT DM.Class, DM.ClassName, DM.Size, DM.SizeName, DM.TDate, Sum(DM.BG) AS SumOfBG, Sum(DM.Demo) AS SumOfDemo, Sum(DM.DTP) AS SumOfDTP, Sum(DM.FAS) AS SumOfFAS, Sum(DM.FM) AS SumOfFM, Sum(DM.HPM) AS SumOfHPM, DM.Division FROM DM GROUP BY...
  20. I

    Update query - calcualte a percentage input by user?

    Dear Minty 6 years ago I was member of this forum... so how could I know that this topic has discussed. I will as the question that I need. If this is a knowledge base forum... .then you must help me by solving my problem... your remarks are not appreciable. irsmalik
Top Bottom