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 TouchToneTommy 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: CSdjohnson
  • Content: Threads
  • Order by date
  1. CSdjohnson

    values for TAXSTTS1 field in export file

    Anyone know what the acceptable values of the TAXSTTS1 in the accpac 5.1 import file are and what they indicate to accpac when importing?
  2. CSdjohnson

    Field descriptions on export file

    Anyone know where I can get free information on field relationships in the accpac 5.0 export/import csv file? I am writing an export from a rental package my company developed to be imported into accpac. I have a csv file generated by accpac but can not find any information on what all the...
  3. CSdjohnson

    two sound cards

    I have two sound cards. one on my motherboard and one in a PCI slot. I am running mandrake 9.2 Both cards are detected but the system is using the one on the motherboard and I want to use the one that I have in the PCI slot. How do I tell linux which sound card I want to use? Do I have to...
  4. CSdjohnson

    getting the max number from a string field

    i have a database with a column called custnum of type char. if i have the following customer numbers in the database: 1 2 3 4 5 6 7 8 9 10 then it is stored like this in the table: 1 10 2 3 4 5 6 7 8 9 i am trying to get the highest custnum so far so that when a user is adding a new customer...
  5. CSdjohnson

    getting max number from a char column

    i have a table with a string column called custnum. the customer number can be alphanumeric. if i have customer numbers 1,2,3,4,5,6,7,8,9,10 and i run the following query: select max(custnum) as newnum from dbo_customers where type_cd = "C" and isnumeric(custnum); then i get a data...
  6. CSdjohnson

    help combining excel sheets

    I have two excel spreadsheets and there are three columns that I need to have match in both sheets. I have columns for sec salesman, sec custname, sec custloc for an invoice number. some of the rows are filled in and some are blank. on a second sheet I have the same thing, but the information...

Part and Inventory Search

Back
Top