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!

Register Log in
  • Congratulations derfloh 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: *

  1. jrhessey

    convert string to time

    That worked, awesome! Thank you both for taking the time to answer!
  2. jrhessey

    convert string to time

    ...whileprintingrecords; stringvar v_hours := split(totext({WOO_HistoryTransaction.StartTime},[highlight #729FCF]"#.##",2[/highlight]),".")[1]; stringvar v_minutes := split(totext({WOO_HistoryTransaction.StartTime},"#.##",2),".")[2]; time(v_hours & ":" & totext(tonumber(v_minutes)*.6,"#",0))
  3. jrhessey

    convert string to time

    Hey guys, I've got a couple fields I'd like to convert to time. The string looks like 6.000 or 20.500. Both values would be 6:00am and 8:30pm. I'd like to get it to a time format as well so I can append it to the date using the dateime function. I've googled and everything I have tried has...
  4. jrhessey

    MSAccess DB with button to print Pick Sheets/SO's

    I am creating an Access DB mainly for ordering tracking purposes. I would like to be able to add a button to the form that would allow me to pass the order number and print the corresponding pick sheet or sales order, via VB, without having to log into MAS90. I did some searching, could find too...
  5. jrhessey

    conditional format (change font color) based on group footer field

    CR 8.5 is the version I'm on. What I have is a database of baseball players and would like to format the players sums and averages so that if they are in the top 3 color the font red or whatever. I have 2 groups, g1 is stats.player and g2 is stats.opponent. The avg field for example for the...
  6. jrhessey

    Like Formula, picks up some, not all fields

    I'm trying to figure out what I've done wrong, but can't seem to make sense of it. I'm trying to conditional formatting of fields that have certain text in a description. Here is the formula: if {SO_24CRWPickingSheet.ItemDescription} like "Discontinued" then crBold else if...
  7. jrhessey

    Running Total for latest record works most of the time

    Damn that looks simple... Can't believe I didn't think of that. Man do I feel stupid right now... Tried it, worked great, as usual, LB! Thanks for your help again!
  8. jrhessey

    Running Total for latest record works most of the time

    First off thanks for your help LB, I hope I don't confuse you more with this post, but here goes... I left out the fact the want two qty's purchased, one for this year to date, and one for last year to date. The same with unit price. They want the qty's summed and the latest unit price for...
  9. jrhessey

    Running Total for latest record works most of the time

    ok, I didn't get it completely right... The Previous year still isn't working. Current year is fine though.
  10. jrhessey

    Running Total for latest record works most of the time

    Nevermind guys, went a different way, and used a formula field instead of a running total field.
  11. jrhessey

    Running Total for latest record works most of the time

    I've got a report that is pulling items purchased and unit price. I've been asked to only pull the latest price though and sum the qty purchased per part number. I've created a group for customer # then a group for item #. In the Item # footer I have qty purchased sum and the running total...
  12. jrhessey

    nth smallest/largest formula for groups

    Sorry about that. Someone called me and I just clicked submit. CR 8.5 & ODBC (MAS90). ** exapmle ** Item # Unit Price 125 .25 .25 .30 .35 .40 What I want to do is create a group for the unit price, becuase nth...
  13. jrhessey

    nth smallest/largest formula for groups

    I'm trying to figure out the nth smallest number for a report the has unit prices in it. I can't get the nth smallest to work correctly because the unit prices are duplicated for our item numbers. Is there anyway I can create a formula that does the nth smallest for groups? Thanks for any help!
  14. jrhessey

    Timestamp in CR 8.5 only shows date

    Thanks for your help guys, rnd's solution fixed it for me.
  15. jrhessey

    Timestamp in CR 8.5 only shows date

    I'm having a problem getting the time portion of a timestamp to show in CR 8.5. The only thing that shows is the date. If I use the same fields in Excel, I get both the date and time. What am I doing wrong? Thanks for any help!
  16. jrhessey

    auto refresh report in CR 8.5

    that's exactly what I'm look for.
  17. jrhessey

    auto refresh report in CR 8.5

    I've been looking in here and on the net trying to figure out is I can auto refresh a report in Crystal 8.5, but can't find anything. Is there any way I can auto-refresh a report in CR 8.5? Thanks for any help!
  18. jrhessey

    Formula field using 5 y/n fields

    NM Synapse. I figured it out! Thanks a lot for your help!
  19. jrhessey

    Formula field using 5 y/n fields

    Synapse - That works great, however, I can not create a group for the formula field now. I sthere anyway I could do that with this formula, or is there another way to do it? Thanks for your help!
  20. jrhessey

    Formula field using 5 y/n fields

    Synapse - You are correct in your assupmtion. I meant the text output based on the fields. Thanks. I will give that a try. Turk - I'm not saying you're incorrect but I have another report with this fomula and it works perfectly... The only difference is that it uses one field form the DB...

Part and Inventory Search

Back
Top