Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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