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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel: How to merge info. from Column A & B into Column C.
Use an 'ADD' operator: a1 b1 c1 08-Apr-03 16:05 08-Apr-03 16:05 Here c1 = a1 + b1 Value in c1 will be proper only if 1. a1 and b1 are entered (not formatted) as date and time respectively. The idea is that value for a1 must not contain a time reference and that for b1...- spmall
- Post #8
- Forum: Microsoft: Office
-
If I am able to classify data based
If I am able to classify data based on certain criteria, then which one is preferable: 1. Having one table with criteria columns 2. Having a separate table for each criterion 3. Having separate users based on one criterion and separate tables under each user for remaining critaria I am trying...- spmall
- Thread
- Replies: 0
- Forum: Oracle: All versions
-
Character limit in Excel 2000
Yes! Click Data->Validation->Settings and define your limits under 'Allow'. Thanks SPM- spmall
- Post #3
- Forum: Microsoft: Office
-
updating a field without going through each record
select 2 use b index on str(checkno)+str(agycode) to temp select 1 use a set relation to str(checkno)+str(agycode) into b replace all ttype with .t. for checkno=b.checkno and agycode=b.agycode close all erase temp.idx- spmall
- Post #3
- Forum: Microsoft: FoxPro
-
word document appearing from previous network user!
This is available in MS Word Online Help: Show or hide the list of recently used documents on the File menu ------------------------------------------------------- On the Tools menu, click Options, and then click the General tab. Select or clear the Recently used file list check box. When...- spmall
- Post #3
- Forum: Microsoft: Office
