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

    Equipment needed?

    What would I need to setup a home wireless network? I have a cable modem, so I assume I would just plug the incoming cable to a wireless router. Then, would each of the PC's/Laptops need a wireless card to connect? What type of card. Sorry, so basic questions. I checked FAQ's and White...
  2. genekr

    ToText/ToNumber not working for number field

    I have a field that is a number field and is displayed 20,051,101.00 which is a date 20051101. I need to take just the 5th and 6th char's to be able to sort by Month. I've tried (ToText(mid({APDISFIL.AP_DIST_DATE},5,2))) but get error "A string is required here" and it highlights...
  3. genekr

    Wrong field values displayed

    I have a report where I have a parameter that selects from a drop-down menu that display's all the default values in a field. There is only 1 table in the report. CR9, PSQL9, W2K3. When I select one of those values, it displays all of the values in the field rather than just the one I...
  4. genekr

    Create view in PSQL 9

    Good morning. I'm very new to PSQL and need to create a view. Is it possible to take a value, have that value in a view and take the first 5 char's and put that in another field and the second 5 chars and put that in another field. My result should be like: Item Main...
  5. genekr

    Do not include items where 8th & 9th char = PE or RE

    I have a report where I do not want to include any item numbers where the 8th & 9th char's are PE or RE. CR9, PSQL9 Server 2003. This is my formula: (not ({IMITMFIL.ITEM_NO} startswith ["ALMISC", "ALSCRAP", "AWELD"])) and {IMITMFIL.ITEM_NO} >= "A%" and {IMITMFIL.ITEM_NO} <= "AZ%" and (not...
  6. genekr

    Parameter Mask

    Is there a way to take a field, xxx4402xxx, and in the parameter select only char's 4,4 to run the report on? I thought I could do it with mask, but am having some difficulty. Thank you. Gene
  7. genekr

    Insert Sum into Formula?

    Crystal 9, PSQL 9, W2003 server. I have a report where I'm taking a specific Code Category, Sale amount, dividing it by Lbs sold to get $/Lb. Code Total Lbs Sold Sale Amount $/Lb 60 172.80 $392.80 $2.2731 For Total Lbs Sold I'm using {Qty...
  8. genekr

    Take certain chars from a field and multiply by another field

    I have a field AO2A200PE. I want to take the 5th, 6th and 7th characters (200) and multiply by another field (7.20) and get a result (1440.00). Crystal 9, PSQL 9, W2003 Server. Any help is appreciated. Gene
  9. genekr

    Date Conversion

    I have a numeric field used for the date on a Pervasive SQL Server v9. The field is numeric and is format 20060101. I need to convert this to a mm/dd/yyyy field to use in Crystal Reports 9. Can this be done in Crystal? Gene
  10. genekr

    Pivot Tables in Excel

    Hi. I have an interview tomorrow for a job the requires knowledge of Pivot Tables. While I have a basic understanding and know how to use them, I was wondering if anybody had a source on the net where I could read up on it a bit more. Thanks. Gene
  11. genekr

    How Secure is Windows XP Firewall?

    I just got hooked up with cable internet. I'm wondering if Windows Firewall is all I need or do I need more? I know the difference between Hardware/Software Firewalls and I have a router that I am going to hook up. I have a current Symantec Antivirus subscription, which I keep updated and...
  12. genekr

    Gateway Solo 3350 Win 98 install

    I have an older gateway solo 3350 laptop. I can have either a 3 1/2 floppy or a CD-ROM connected but not at the same time. I'm trying to load Win 98 and am having problems. I can boot to the floppy (W98 boot disk)and get to a dos prompt, but I have to disconnect the floppy to connect the cd...
  13. genekr

    SQL 6.5 Error

    I'm running SQL 6.5 on a W2K box. While running a SQL Query I get the following error. [Microsoft][ODBC SQL Server Driver][SQL Server]Can't allocate space for object '-547' in database 'tempdb' because the 'system' segment is full. If you ran out of space in Syslogs, dump the transaction log...
  14. genekr

    SQL 6.5 Format Back-up Tape

    I'm running SQL 6.5 on a W2K box. I have a Compaq 15/30 GB DLT tape back-up and I can't seem to find where to format the tape for the back-up. I just bought some new tapes but can't get them to work. Any help is appreciated. Gene

Part and Inventory Search

Back
Top