Search results for query: *

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

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...

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...

Worked like a charm PHV, thank you much

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

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...

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...

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

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

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...

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

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...

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

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...

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...

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...

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

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...

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...

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...