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!

Recent content by genekr

  1. genekr

    Equipment needed?

    Thank you very much.
  2. 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...
  3. genekr

    Create view in PSQL 9

    Super. Thank you very much.
  4. genekr

    ToText/ToNumber not working for number field

    I've tried using Whileprintingrecords; stringvar MyDate:=totext({APDISFIL.AP_DIST_DATE},0,""); val(mid(MyDate,5,2)) and it seems to sort correctly, but I also need to group by the month and when I try it the @month formula, which I uesed above, does not show up a a group option.
  5. 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...
  6. genekr

    Wrong field values displayed

    Thank you. I'm embarassed. I must have had a really bad brain cramp this morning. Thanks again for your assistance. Gene
  7. 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...
  8. 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...
  9. 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...
  10. genekr

    Parameter Mask

    I may not have been specific enough. CR9, PSQL9, W2003 server. The user is only going to know the 4 digit number, not the whole string. Is it possible to have them enter a parameter of 4402 and have the report select file xxx4402xxxx ?
  11. genekr

    Parameter Mask

    Thanks all. I'll try it. Gene
  12. 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
  13. genekr

    Insert Sum into Formula?

    Yes, grouped on {imitmfil.item_prod_cat}

Part and Inventory Search

Back
Top