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

    Selecting random records in Crystal

    I read the threads copied below. I created a formula RND() and put it into the details section of my report and it returns a decimals starting at 0.00259 to 0.99625. How can I format the field to produce whole numbers for a select statement of Random <= 25? Thanks Dorrie...
  2. dfor

    create a date/time field from two fields date/time &amp; time

    Using Crystal 8.5, I am trying to query events logged between two dates (datesql) and between two times (timesql); e.g. June 1 @ 08:00 to June 2 @ 07:59. Datesql is a date/time field that does not capture any associated time value. Timesql is a time value like: 08:30 I thought if I converted...

Part and Inventory Search

Back
Top