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

    conditional join (I think) in SQL

    I am trying to join a field (in table 1) to table 2 or table 3 depending on the value of a another field in table 1. My COMM table (1) looks like this: CommID User ID Type 100 987 SER 101 123 EMP SER (2) and EMP (3) are tables that will give me information about those...
  2. sheriberi

    date less than 30 days from another date

    I am trying to look at patients with a test date within 30 days before their procedure date. So if the test was 20 days before the procedure, they count as Yes. But if the test was 31 days (or more) before the procedure date, they don't count (No). What I am using is calculating correctly...
  3. sheriberi

    need to use variables in a crosstab - HELP!!!

    I have a Crystal 2008 report that is displaying data via "Whileprintingrecords" variables in the group footer. I really need to make a Crosstab using the data in these fields, but they aren't available to the crosstab. I get why, but is there any way around it?
  4. sheriberi

    extract part of a string

    I have a string of data that is a concatenation of a various number of items separated by a , I need to extract the last value every time. How can I write that formula?

Part and Inventory Search

Back
Top