Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Remove spaces from a string
- I'd like to remove all of the spaces from every string value contained in a particular column of an Access 97 table. I'd like something a little easier than looping through a DAO recordset, but that will do if someone can help me with the code as I'm a bit...
- Tags: afisher@..., programming, UPDATE table SET
- Q&A 2005-08-10
Additional Resources
- Dynamically adding a column to temp table
- Hi,I am trying to Dynamically add a column and also update the temp table. But I am getting error message like "Server: Msg 170, Level 15". Is there any way that I can solve this. Very urgent. Thanks in advance. My code goes like this. set @tempvar = 'name' +...
- Tags: laxmijk11@...
- Discussion threads 2007-09-26
- Store Result of SELECT stament to be used to UPDATE another table
- Hi, im trying to update a field of a table which is done through the results of a select statement. I need to be able to a store the results of the select statement which can then be used to determine if an update another table is initiated. This is...
- Tags: Notebooks, twanstall@..., laptop computer
- Discussion threads 2007-03-24
- OnLoad update table depending on Y/N value of another table
- Hello,I need to update a field in a table that has 2 fields:LaptopNameStatusID I have another table called loans, in this table one of the fields has a complete Y/N value (depending on whether the loan is complete, i.e. returned laptop to me)i need to make it so that "Onload"...
- Tags: twanstall@..., OnLoad
- Discussion threads 2007-03-23
- Microsoft Access 2000
- In a database file of 1000 names, how do I enter a check character in a field called MAILso that all records indicate YES. I know I can do it manually one record at a time, but is there a way to modify the table or create a query...
- Tags: Databases, Microsoft Corp., Microsoft Access, RCBLT@...
- Discussion threads 2007-04-13
- Using SQL Triggers to update Tables.
- I have a table called SALE, which is populated using BCP. The SALE table is missing the Retail Price since it is not in the BCPed file and needs to be read in from another table.The SALE table has an insert trigger that it uses to populate MONTH_SALE. My question...
- Tags: MONTH_SALE, Sale
- Q&A 2005-03-08
- Update data from one table to another table
- Greetings:I have two sql 2000 databases, one on one server and one on another server. After bringing in the data from one table, I would like to update the other database table with the changed data.Quick and dirtyTruncate Table OutOfDateInsert OutOfDate Select * From UpToDate
- Tags: Storage, Databases, greg_gordon@...
- Discussion threads 2007-07-23
- How to update many records in an Microsoft Access file?
- I have a huge table with many fields or columns and with more than 50,000 rows of data. But I have to insert data in one column-location with respect to another column-access randomly. By using action query I can update only one record at a time. Another solution I think...
- Tags: Databases, vamshna@..., Microsoft Access, Microsoft Corp.
- Discussion threads 2007-03-29
- how to optimize a update query
- i am using sql server , and try to update a table a single field with a update query " update table alpha set field1='23' where field2='asd'"now i have to run this kind of query 70 times/sec .Now in some cases query takes 7 ms to complete , but some...
- Tags: Databases, amitbharadwaj@...
- Q&A 2005-07-01
- Table captions in MS Word
- You can automatically add captions to tables in word that will increment the numbers as you go. Is it possible to link any references in the text to this table so that if you change the table number the rferences in the text will also auto updateYes. You need...
- Tags: caption, edward.jordan@..., Microsoft Corp., Microsoft Word, software
- Q&A 2005-05-03
- Update Queries/Make Table
- I have a overtime database in which the bulk of the data resides in the tblhours which tracks each and every occasion of overtime they have. Once a year, per our union contract, we have to rollback the overtime subtracting the lowest person's overtime from the each and every...
- Tags: mcrouse@..., overtime, hoursWorked
- Discussion threads 2007-04-27
- Displaying a table with many rows on a form Access 2003
- Access 2003 question.I have a Table of projects and a table or tasks. Linked by project number. How do I design a form to display query results to show all the tasks related to a project. And then, be able to update a field on each task displayed...
- Tags: daniel.fabeck@..., Microsoft Access, Access 2003
- Discussion threads 2007-11-09
- Formu;las in Access to update a table
- I have a form with 3 fields. Each field is from 3 seperate tables. I want to add together the value of two of the fields and update the third field. the third field has an existing value that will be updated with this formula. I have a formula that...
- Tags: Microsoft Access, software, teke
- Q&A 2005-01-23
- Optimise the update of a table from another one
- Hi,I have 2 tables,Product: Product_code, value1, value2 ( 300 000 records )Orders: Product_code, value1, value2 ( 1 000 000 records )I'd like to update Orders from Product. I'am using the folowing statement:updateset orders.value1 = product.value1,orders.value2 = product.value2from orders, productwhere orders.product_code = product.product_codeIt takes minutes and minutes to update. I created...
- Tags: jacques.hellio@...
- Discussion threads 2007-09-28
- Never ending UPDATE
- I ran this query in the Query Analyzer for 6 hours and then gave up. 29 million recs at 24GB.Update ASet Acctid = B.AcctidFrom BWhere Substring(VendId,5,4) = B.VendId4I did a link from Access and Access took 4 Hrs but it worked for 5,3.Any suggestions will help me understand the SQL...
- Tags: Databases, JBNY, Substring
- Discussion threads 2007-10-24
- MS Access
- I would like to updete fields in existing Access table. I would like to add fields in that tableHmmUpdate as in change the data, from access, open the table and type, From SQlUpdate MyTable Set MyField1 = 'Value',MyField2 = 123.8 Where MyKey = 1To change the structure of a tableFrom...
- Tags: ashishab@..., vb, access database, software, Microsoft Corp., Microsoft Access
- Discussion threads 2006-08-28
- Inserting data from one table in access into another
- I am creating an access db, and I've imported an excel spreadsheet into the db. I've created the table in access with the fields that I want to have in the table, but I am drawing a blank on how to update the table in access with the excel...
- Tags: Microsoft Excel, daintysally
- Discussion threads 2007-10-15
- Many to one database question
- Can someone pls help me!!I have 2 tables in a database for Project/Workflow tracking. One table Actions table contains a detailed list of actions with a status column.The other table contains each project Project table.I need a query to update the Project table record for a particular project when all...
- Tags: access, ACTIONS, Complete, database, Project, Project Table, Projects, robynty@..., software, sql
- Discussion threads 2005-07-27
- Mailbox Tools for Eudora (zip)
- Mailbox Tools for Eudora is compilation of several related programs which goal is to update Eudora's mailbox table of content or mailbox files. Some of the key features include Mark All Messages Sent/Received. Update Sent-Received Status. Update Priority/Attachment Links/Date-Fields. Update and Decode Subject-Fields. Update and Decode Who-Fields. Harvest E-Mail Addresses....
- Tags: Eudora, Mailbox, Tool, E-mail Clients, Groupware, Software, Enterprise Software
- Software downloads 2007-01-17
- Generating Codes with Update Query
- Hi all,I am generating a multi source concatenated code with an update query in Microsoft Access. I am wondering if there is a way to cut the update to only new entries rather than updating all records each time the query is run.Any helpers for this problem?A variant ofUpdate MyTable...
- Tags: jim@..., Update MyTable Set, Update MyTable
- Discussion threads 2007-04-25
- << Previous
- page 1 of 1
- Next >>
