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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. OU18

    Column w/ Multiple Issues

    Hi all, I have an issue with some data that is sent to me from another company. I work in telecom, and we recv rate changes from vendors. Some weekly, some daily, some monthly. There really is no rhyme or reason to the way they come in. The issue I am running into is, there are multiple...
  6. OU18

    Minimum Value across Multiple Columns

    All, How can I rank the minimum values across multiple columns in a row for each RouteID value. ex. Route ID A B C D E 1 .05 .06 .007 .10 .09 2 .05 .08 .099 .11 .04 3 .10 .03 .12 .002 .10 So the results would look as follows Route...
  7. OU18

    Sum of Prev Months Records

    All, I am trying to do the following. Table: tblInvoiceTransactions Fields:AccrualMonth,InvoiceAmount,AccountID. What I need to do is generate a query that when the accrual month is entered (IE. 8/1/04.. the accrual month will always be the first of the month)the query will create 3 columns...
  8. OU18

    Linking from Remedy to Another Application

    Hello All, I am using Remedy 5.0 and have a quick question. Is it possible to link remedy to another application to pull data into remedy. IE Access 2000 table feeding a field in Remedy. Thanks Steve
  9. OU18

    Previous record

    All, I have a need to retrieve the last record for a particular account id, and the second to last record for the same account id. the tables involved are TblAccountInformation Fields - AccountID, AccountName tblInvoiceTransactions Fields - AccountID(links to...
  10. OU18

    Parsing in a Query

    All, I have a field Circuit ID, that has varying lengths of data in it. However there are certain portions of the record I am looking to remove from the field. Circuit ID 2001 T3XF PHLAPAFGK22 PHLAPAAZK03 x19 I need to remove the portion of the data that is x19. The records have an x and then...
  11. OU18

    Moving Columns Automatically in Query

    All, Is it possible to move the columns in a query based on some criteria. Example, If I want the column with the lowest digit to appear as the first column, and the second lowest as the second column, etc. This would change each time the query is run due to different rows having different...
  12. OU18

    Drop Down List and Groups

    My question is. Is it possible to limit one selection in a drop down box, so that only a specific group can use it. I have it working if the user logged in belongs to 1 group. But because we have users belonging to multiple groups it fails and will not work. Thanks for your repsonses in advance
  13. OU18

    Creating Relationships on demand

    Hi All, I am trying to create relationships between tables on demand. Meaning, user selected. I have been charged with building an Inventory Database for our network circuits (ie OC48,DS3,DS1,DS0). Under normal circumstances you couldnt have a DS3 without an OC level circuit. But at our company...
  14. OU18

    Removing a Date String

    Hi all, Was wondering if someone could help me with this little issue i am having with creating a query to pull out a date string from a field. the fields data looks like this. FieldName = SV_DESC CONF:7/26 #(4) MIN(99) 800PC I need to pull only the information 7/26 from the field. Note...
  15. OU18

    Compare Current record to other Records

    All, I am looking to create a query or code that will do the following. I have a table that has the following fields table - tblInvoiceTransactions BAN AccrualMonth InvoiceDate ApprovedforAP For each Accrual month there can be multiple entries IE Ban Accural Month...
  16. OU18

    Network Shutdown

    All, Can anyone tell me how I can force a shutdown of a network Access 2000 database. It is shared by multiple users. I dont want to institute an inactivity timer to shut down. I need this for purposes of making changes to the database that require all the network users to be logged out of...
  17. OU18

    Auto Creating Records

    All, I am in need of a way to auto create records based on a circuit level field. I have been tasked with creating a circuit inventory DB to track company facility assignments. Scenario: A user is entering a new facility assignment. IE OC48. Which is assigned a unique id (autonumber). When...
  18. OU18

    Netgear RP614V2 Router/ Comcast HSI Problem

    All, I have the following problem with my Broadband Connection I called in registered the Motorola SB5100 modem as I should. It was connected directly to my computer at the time of install. It worked flawlessly and still does when connected directly to the computer. I, like many of you, have...
  19. OU18

    Inherited Database - Need Help

    Hello all, this may get lengthy, but bare with me. I have inherited an Access 2000 Database that needs alot of scrubbing What I have is 1 Massive table that contains our companies circuit inventory. The problem is that one circuit can have multiple row entries associated to it. Each of the...
  20. OU18

    Creating Multiple Entries

    Here is my question. I would like to have the user hit a button and have it automatically create 28 records. Where i will push certain linking information to child record. I am developing a F&E system utilizing remedy, and need to have the ability for the user to click a button once a DS3 has...

Part and Inventory Search

Back
Top