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!

Recent content by sirskeezy

  1. sirskeezy

    Calculating Percentile Values

    I think I gave up on the SQL route.. I am trying to calculate percentile values by using your VBA code: Public Function DPercentileExcel(expr As String, domain As String, Percentile As Double) As Variant Dim strSQL As String Dim N As Integer Dim nSubk As Double Dim vSubk As...
  2. sirskeezy

    How do I make my queries run faster?

    I just realized that I did not explain why I have multiple queries instead of one query holding multiple calculated fields. It is because each calculated field has null values (which I can't count because it messes up my percentile calculations) and I need to set criteria "is not null" for me to...
  3. sirskeezy

    Calculating Percentile Values

    I changed all my names to have no spacing and no special characters. My SQL is now working but is there a way to exclude null values in my SQL code? Right now I have my SQL looking like SELECT Max(STEP2_FactorVariables.MaintenanceCostsPerSF) AS MaxOfMaintenanceCostsPerSF, FROM...
  4. sirskeezy

    How do I make my queries run faster?

    Hi all, I am in the midst of moving an Excel model and database into Access and have come up against the very annoying problem of my query taking wayyyyyyyy to long to run. First to provide a better understanding of my situation, here is how my model in Access is structured: First I have a...
  5. sirskeezy

    Calculating Percentile Values

    then i don't understand why when i try to run my query it says that in the SELECT state ment theres a reserved word or argument name that is misspelled or missing, or the punctuation is incorrect :( the sql i wrote is SELECT [Percentiles].[percentile], DpercentileExcel("operating...
  6. sirskeezy

    Calculating Percentile Values

    ooooh ic... also, is qryCostPerSize the name of the query u made for the operating costs/property size?
  7. sirskeezy

    Calculating Percentile Values

    SELECT tbPercentiles.percentile, DpercentileExcel("costPerSize","qryCostPerSize",[percentile]) AS PercentileValueExcel, Dpercentile("costPerSize","qryCostPerSize",[percentile]) AS PercentileValue FROM tbPercentiles ORDER BY tbPercentiles.percentile; what is the Dpercentile in ur sql...
  8. sirskeezy

    Calculating Percentile Values

    Ok thanks MajP, I've created a new module and first put in Public Function DPercentileExcel(expr As String, domain As String, Percentile As Double) As Variant Dim strSQL As String Dim N As Integer Dim nSubk As Double Dim vSubk As Variant Dim vSubkPlus1 As Variant Dim...
  9. sirskeezy

    Calculating Percentile Values

    Wow these VBA codes look really promising, I'm going to try them out now. Because I am a complete noob at this, do I just copy n paste the first part into a module, then copy and paste the second part underneath it with my table name and field?
  10. sirskeezy

    Calculating Percentile Values

    Is there a way of doing all this in VBA?
  11. sirskeezy

    Calculating Percentile Values

    :S still does not seem to be working, I get a error message regarding 'tblOperatingCosts.ID' btw the query is going against my Raw Data table
  12. sirskeezy

    Calculating Percentile Values

    Yes, the table name is called Raw Data and operating costs and property size are 2 fields that are in that table
  13. sirskeezy

    Calculating Percentile Values

    Hey MajP, The thing is, there isn't a table for operating costs separately so I think that SQL code wouldn't work in my case...
  14. sirskeezy

    Calculating Percentile Values

    Hi, I've been searching up how to calculate percentile values all day and I still do not seem to be able to get the values that I want. Can someone please help me? Heres the overview of my situation: I have a table called Raw Data and it holds fields including 'operating costs' and 'property...
See more

Part and Inventory Search

Back
Top