Search results for query: *

I figured it out. My query is just fine, I am using a field that I shouldn't...AAARRRGGGHHH!!!! Thanks though! Problem solved

Also.....(I do really have a comma after the * in the select stm). The syntax of this query is okay. I am getting results. I am just not getting correct results. I am getting correct results for the row that has EMP in the Type, but am getting NULL in the row that has SER as the Type when I can...

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...

I got my answer on another site's board and it works beautifully if anyone ever needs to do same: You may need to ensure the testdate is before the procedure date if ({TEST.DATE}) >= DateAdd('d',-30, {PROCEDURE.DATE}) AND {TEST.DATE} <= {PROCEDURE.DATE} then "Yes" ELSE "No

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...

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?

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?