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 Rhinorhino 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: *

  • Users: OU18
  • Order by date
  1. OU18

    Rounding to the nearest 100

    All, Is there a way to make this work so that it will round up to the nearest 100 no matter if it is below 50 or not IE 736 would round to 800 instead of down to 700. Thanks
  2. OU18

    Checking Existence of Table

    All, How can I have my database on the click of a radio button check to make sure that linked tables dont already exist. I have a button that when clicked automatically links the table to my db. What I want is when you click the button, for the system to look and see if it is already linked...
  3. OU18

    Finding Missing Dates

    PHV, Is there a way to modify this query so that it will also look forward. IE. The last Accrual Date may be 3/1/2005. But the current date is June 8, 2005. According to the query listed above, it will show any months that are missing Prior to 3/1/2005 but will not show the missing months of...
  4. OU18

    Finding Missing Dates

    Worked like a charm PHV, thank you much
  5. OU18

    Finding Missing Dates

    I will give that a shot and see if that helps it out
  6. OU18

    Finding Missing Dates

    PHV, Your solution runs quickly doesnt produce the final information I need. It gives me the Accrual Month and then the month just before it. How can I now come up with the Actual missing date. Golom, Your solution looks very detailed and looks as though it would work great, Yet it takes...
  7. OU18

    Finding Missing Dates

    All, Is there a query that I can write that will take a field that contains a standardized date and find the one that is missing IE Acct ID Accrual Month 205 1/1/2004 205 2/1/2004 205 3/1/2004 205 5/1/2004 205 6/1/2004 206...
  8. OU18

    Creating relationships for imported files

    Craig, I have a similar situation where I want to have the relationship between two tables link automagically. This code looks as though it would work for me. But where do you place the lines of code. In the Sql of a query, in a module. Any help is greatly appreciated. Thanks
  9. OU18

    Ranking Prices

    PHV, This more then helped. You just saved me a whole lot of going between programs. Have a star
  10. OU18

    Ranking Prices

    PHV, Yeah the code is Function GetRank() Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("Select * from tblSteve") Dim i As Integer i = 1 While Not (rs.EOF) rs.Edit rs!rank = i rs.Update rs.MoveNext i = i + 1 Wend rs.Close End Function There are actually two...
  11. OU18

    Ranking Prices

    Okay, That worked great but one small problem. It just created a number from 1 to X regardless of region id. Is there a way to modify the function so that it will number 1 to x for each region based on region id. Thanks for the help
  12. OU18

    Ranking Prices

    PHV, In my case, the rank only changes once a month. The prices are good for an entire month. Also, I have tried the above it runs terribly slow. My table is some 5.2 million records. Originally my table had 401,000 rows with each vendor in its own column. What I was truly trying to accomplish...
  13. OU18

    Ranking Prices

    Gnger I get the same error. Here is the code I used Function GetRank() Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("Select * from tblSteve ") Dim i As Integer i = 1 While Not (rs.EOF) rs.Edit rs!ranking = i rs.Update rs.MoveNext i = i + 1 Wend rs.Close End Function
  14. OU18

    ranking for multiple columns

    I have a similar situation where I have multiple rows of geographical regions with each having multiple vendors (Columns) that offer differing rates. I need to rank each vendor by their rate. I have found several entries in the forums on ranking, and they do work, but they take a long time to...
  15. OU18

    Union Queries and Top N

    Also, Here is some history behind the union query. My table is currently listed in Columns. Qwest ER NTera ER Global ER US Lec ER In the columns is a rate for each of these vendors. What I was initially needing to find was the top 3 Mininum Rates within the columns by Route ID LATA. It was...
  16. OU18

    Union Queries and Top N

    PHV, I tried your query and it locks up my machine. It appears it is running, then the screen goes blank and locks up. PaulBricker, I have also tried your query. It runs very quickly, however it does not give me the data I am looking for It appears to list the top 3 ROUTE ID LATAs. What I need...
  17. OU18

    Union Queries and Top N

    PaulBricker and PHV thanks to both of you for the quick responses. I will give them a try. I appreciate the help Steve
  18. OU18

    Union Queries and Top N

    All, Is it possible in a union query to only bring in the top 3 lowest rates per Route ID LATA. I have pasted my query below. There can be mulitple RATES per ROute ID LATA. SELECT [tblLATARATE].[ROUTE ID LATA],[tblLATARATE].[3 DIGIT LATA],[tblLATARATE].[OCN], [QWEST ER] AS RATE, "Qwest ER" AS...
  19. OU18

    Assigning a Rank

    Golom, I modified what you sent me to the following SELECT (Select count(*) from [tblLataRate-List] Where [Route ID Lata]=[t].[Route ID LATA] and [ID]< [t].[ID])+1 AS Seniority, t.Vendor, t.[ROUTE ID LATA], t.RATE FROM [tblLATARATE-List] AS t; And it works great with one small exception...
  20. OU18

    Assigning a Rank

    All, How can I write a query to assign a rank of 1,2 or 3 to a table. What I currently have is data like the example below Route ID Price Vendor Rank 1 .005 X 1 .006 A 1 .007 C 1 .009 D There are multiple Route...

Part and Inventory Search

Back
Top