No announcements
Found 2935625 threads
-
4 VotesIf duplicates in a field in a table, keep only the highest number from another field.
keep only the last record from the field MAHFAC_NO_LIGNE, that way I would have only the current status for that ...Answered | 6 Replies | 317 Views | Created by Claude Larocque - Friday, February 9, 2018 8:37 AM | Last reply by Claude Larocque - Saturday, February 10, 2018 7:19 AM
-
0 Votes
Update a number field in a table
If I didnt have a field in tblInvoice ClientName then the Invoice wouldnt have a Name on it, I have say 200 Clients I coudnt remember all their ...Discussion | 16 Replies | 1522 Views | Created by TurnipOrange - Sunday, August 4, 2013 10:22 PM | Last reply by Tom van Stiphout (MVP) - Tuesday, August 6, 2013 2:10 PM -
0 Votes
Find highest number in alpha field
Hello, We have an AccountID field that is a text field. I need to get the highest number of this field to increment ...Answered | 4 Replies | 1852 Views | Created by Albert S - Tuesday, September 20, 2011 11:21 PM | Last reply by Albert S - Tuesday, September 20, 2011 11:52 PM -
2 Votes
Label in a chart - another field from the table
Hi CharlotteTC, According to your description, you want to display Rotul field from the table in the chart, I'm right? ...Proposed | 6 Replies | 414 Views | Created by CharlotteTC - Wednesday, June 14, 2017 2:38 PM | Last reply by Cherry Bu - Wednesday, June 28, 2017 6:24 AM -
2 Votes
Getting the highest number from a Field(Row) in a database
If you want the highest value from a row in a textbox then normally is used the Top in the select ...Answered | 5 Replies | 3470 Views | Created by Boiling Lava - Sunday, May 8, 2011 9:45 PM | Last reply by Mike Feng - Friday, May 20, 2011 8:16 AM -
0 Votes
Require a Field Only if Another Field is filled out
Is it possible to create a formula for a calculated column, to make the column be required only if another column has something entered ...Answered | 3 Replies | 1821 Views | Created by TSlocum - Thursday, May 9, 2013 6:55 PM | Last reply by TSlocum - Friday, May 10, 2013 12:41 PM -
2 Votes
Update the field “customer_id” in a table based on an ID field from another table
Hi, I would like to update the field “customer_id” (not primary key) in a table named “tblInternetDépôtsCSV” based on an ...Answered | 7 Replies | 702 Views | Created by Claude Larocque - Sunday, August 7, 2016 5:55 AM | Last reply by Claude Larocque - Monday, August 8, 2016 8:49 AM -
7 Votes
Summing a field if another field = scrap
I'm working on a report where I need to sum a field if another field=scrap. Hello, Did ...Unanswered | 16 Replies | 1641 Views | Created by Shi Rumptz - Tuesday, January 28, 2014 9:28 PM | Last reply by Kalman Toth - Sunday, February 2, 2014 10:29 AM -
0 Votes
Removing duplicates from a table with an xml field
structure from the first one(select with a never satisifed condition in the where clause). Then insert rows from the first ...Answered | 2 Replies | 4345 Views | Created by w84me - Wednesday, September 3, 2008 7:32 PM | Last reply by w84me - Thursday, September 4, 2008 4:19 PM -
0 Votes
How can Update the field from other table field if only other table field had value ?
Hi, How can Update the field from other table field if only other table field had value ...Answered | 7 Replies | 1756 Views | Created by Sign of Shine - Wednesday, September 4, 2013 6:11 AM | Last reply by Sign of Shine - Wednesday, September 4, 2013 7:38 AM -
0 Votes
Updating a field in one table with the value from a field in a different table
Is there another preferred way of getting this accomplished? Or is the use of the temp table the right approach? Can i do a direct update to ...Unanswered | 10 Replies | 3791 Views | Created by Spawn10 - Thursday, December 31, 2009 4:54 PM | Last reply by Kalman Toth - Sunday, January 10, 2010 11:00 AM -
0 Votes
Change the only word in a field!
Does the Category field contain only the single word "Gallop", or is the word embedded in other text ("the horse was ...Answered | 3 Replies | 4494 Views | Created by TurnipOrange - Wednesday, August 18, 2010 11:24 PM | Last reply by Allen Browne - Thursday, August 19, 2010 1:42 AM -
1 Votes
Alter Table. Problem if field name is a number
Hi I am trying to programatically add columns to a temp table based on a set of values passed through from a select on ...Answered | 3 Replies | 5301 Views | Created by bob132 - Thursday, April 7, 2011 12:37 PM | Last reply by Kent Waldrop - Friday, April 8, 2011 5:50 PM -
0 Votes
Find the field with highest number - xslt?
I have below message processed in BizTalk, my requirement is I need to fetch "EmployeeNumber" field which has the max number and find its related fields ...Unanswered | 6 Replies | 1425 Views | Created by Dan2890 - Tuesday, December 3, 2019 6:53 PM | Last reply by la Cour - Thursday, December 12, 2019 6:05 AM -
0 Votes
Update a field in a table based on another table.
If you are interested in this UPDATE ...FROM ..JOIN... thing, you can find something to read many years ago.Answered | 4 Replies | 426 Views | Created by 98108 - Tuesday, November 17, 2015 7:40 PM | Last reply by Jingyang Li - Tuesday, November 17, 2015 9:43 PM -
0 Votes
Pivot Table Duplicates Values in Field List
Hi, I made a pivot table from a set of data and it looks like table made a duplicate of all the ...Unanswered | 3 Replies | 1541 Views | Created by Lo Saeyang - Tuesday, October 23, 2012 11:14 PM | Last reply by Cindy Meister MVP - Thursday, October 25, 2012 7:11 AM -
0 Votes
Math in a number field
string...if it can eval to a numeric result, then you can use it... or you could just fire up the windows Calculator app... ...Answered | 1 Replies | 4039 Views | Created by DriveEV - Wednesday, September 15, 2010 7:14 PM | Last reply by Mark Burns - PMADN - Wednesday, September 15, 2010 7:17 PM -
0 Votes
Update Fields in table only if the field is null
Hello, I have to update a production table columns with an incoming staging table only when the value of any of the column ...Answered | 10 Replies | 10259 Views | Created by kesar_k - Friday, February 12, 2010 7:34 PM | Last reply by Adam Haines - Thursday, February 18, 2010 7:22 PM -
3 Votes
Setting the starting Number in a Auto Number field.
Adam Just in case you want another way to do it, you can run a query to alter the field. Open a new query and switch to SQL ...Answered | 6 Replies | 11682 Views | Created by adam_syd - Monday, June 28, 2010 4:54 AM | Last reply by Bill Mosca, MS MVP 2006-2016 - Tuesday, June 29, 2010 2:27 PM -
0 Votes
Resulting the highest number
that consist of any number from 1-100 I can I get it to result the highest value from ...Answered | 1 Replies | 4131 Views | Created by mark.rooker - Monday, April 27, 2009 9:48 AM | Last reply by mark.rooker - Monday, April 27, 2009 9:51 AM - Items 1 to 20 of 2935625 Next ›
No announcements
