Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DoubleD

    Database Havoc

    This is an excellent idea. Provide an actual proposal with specified software, as well as an estimated cost structure for the project. Now here's the key, include estimated Return On Investment (ROI). If you can show that your proposal will ultimately pay for itself, any sales guy will bite. How...
  2. DoubleD

    How to make multi value field work in crosstab report(Impromptu)

    Mitra, Excellent illustration. Do you have $ Invoiced stored at a Sales Rep level? If so, I would suggest using that value instead of Total $ Invoiced. You can sum the dollars by Sales Rep to get to the Total $ Invoiced. If the data is not available at that level, what is the reason for...
  3. DoubleD

    How to make multi value field work in crosstab report(Impromptu)

    MitraMIS, I don't think I understand what you're trying to accomplish. Could you give us a visual representation of the values? I am what I am based on the decisions I have made. DoubleD [bigcheeks]
  4. DoubleD

    column in report with search case statement

    Could this be a crosstab report instead? Based on a single calculation that returns the # of Days category? I am what I am based on the decisions I have made. DoubleD [bigcheeks]
  5. DoubleD

    Dynamic header in cross tab report

    If you are filtering on the value entered in the prompt, and you have a formatted column in the columns section of the crosstab, then the column headers generated should act exactly as you are suggesting. You should be filtering where your data is <= the entered prompt. I am what I am based on...
  6. DoubleD

    Subform to open a filtered form

    Check out this site for how to correctly reference a subform. http://www.mvps.org/access/forms/frm0031.htm I am what I am based on the decisions I have made. DoubleD [bigcheeks]
  7. DoubleD

    Disabling a command button when a combobox is null

    Private Sub cboAnalyst_Change() If Len(cboAnalyst) <> 0 then cmdLogIn.Enabled = True Else cmdLogIn.Enabled = False End If End Sub I am what I am based on the decisions I have made. DoubleD [bigcheeks]
  8. DoubleD

    Nested Iif problem...

    This version should get you what you want. =IIf([Pricing_Policy]="Individual*",[SalePrice2],IIf([Pricing_Policy]="Included*",[NetUPSP1],IIf([Pricing_Policy]="Standard","Standard",0))) I am what I am based on the decisions I have made. DoubleD [bigcheeks]
  9. DoubleD

    Dynamic header in cross tab report

    If you filter your report on the date entered, then make a date column that is formatted as YYYY-MM, this should display exactly what you are requesting. Unless there is no data for some of the months, then things will get a little more challenging. I am what I am based on the decisions I have...
  10. DoubleD

    How do I hide blank rows?

    Difficult to help as I don't understand your data structure or how it is populated. Try flowcharting what fields you check to decide whether a record should show up in the report. Then build your filter based on the flowchart logic. I am what I am based on the decisions I have made. DoubleD...
  11. DoubleD

    precompute parameters/variables whit sub query values

    I'm not sure exactly how it's done in CRN, but it should be even simpler than this. In Impromptu, you would write a report against just the Date_Info Table: Column1: Fiscal_Year Filter: Calendar_Date = SysDate Thus this report would only return one row, which would be the Fiscal Year of the...
  12. DoubleD

    precompute parameters/variables whit sub query values

    If you have that join defined, your filter would only need to be this: where fiscal_year = Year(sysdate) No user intervention required. I am what I am based on the decisions I have made. DoubleD [bigcheeks]
  13. DoubleD

    How do I hide blank rows?

    Why not just put a filter in your report to exclude all Sales Orders that have been delivered? I am what I am based on the decisions I have made. DoubleD [bigcheeks]
  14. DoubleD

    precompute parameters/variables whit sub query values

    If your DateInfo table has all dates, as well as their fiscal year, could you join to the DateInfo table, then filter on Fiscal Year? I am what I am based on the decisions I have made. DoubleD [bigcheeks]
  15. DoubleD

    different columns of my report needs a different filter condition

    YTD Sales = SUM(IF(YEAR(SALES_DATE)=YEAR(NOW())) THEN (SALES_AMT) ELSE (0)) YTD Sales = SUM(IF(YEAR(SALES_DATE)||QUARTER(SALES_DATE)=YEAR(NOW())||QUARTER(NOW()) THEN (SALES_AMT) ELSE (0)) Last Year Sales = SUM(IF(YEAR(SALES_DATE)=YEAR(NOW())-1) THEN (SALES_AMT) ELSE (0)) || being a...
  16. DoubleD

    Technology allows me to have edited pre-recorded movies...

    I think CajunCenturion hit it right on the head, but I'll clarify my version of it. It is ethical for CleanFlicks to take your individual legally purchased copy, edit per your request, and hand back to you. You are paying for the editing of the movie. It is unethical for CleanFlicks to take...
  17. DoubleD

    How to create a file picklist

    MitraMIS, You could also do a nested POSITION function. Get the position of the first occurence, then get a substring based on that value, then do a POSITION function on the text string you have left. I am what I am based on the decisions I have made. DoubleD [bigcheeks]
  18. DoubleD

    Transformer Date Calculations

    Any reason why you're not calculating the date difference in your IQD? The calculation could happen on the database which should be much more efficient. I am what I am based on the decisions I have made. DoubleD [bigcheeks]
  19. DoubleD

    IWR runtime error cannot connect to DB

    Are you passing the user's Userclass to the catalog, or using Creator as the default? I am what I am based on the decisions I have made. DoubleD [bigcheeks]
  20. DoubleD

    Skills or abaility more important

    Time to earn those management dollars Katy44. Organize your thoughts as well as the pros and cons of your hiring plan. Propose this info to your boss so they understand why you plan to take the direction that you do. If your boss still tells you it's more important to hire someone with knowledge...

Part and Inventory Search

Back
Top