Search results for query: *

thank you Pete!!!! i took some time off during the holidays, but i'm going to play with this right now.

hello world i have a SQL table with a memo field containing string lengths from 1 to ~6,000 characters. the client system can only accept strings that are <=75 characters. i have searched some examples of arrays, but most people seem to be splitting by a delimiter or searching for specific...

Thank you! CASE worked great. This opens up a lot of things I can do with my SQL queries now. THANK YOU!!!

If I could write this query in Crystal Reports or Access, it would be no problem, but I'm no good at SQL variables. I'm sure something is wrong with my IF/ELSE, and I think I have to declare it as a variable first, but I need help with syntax. SELECT [PartitionID], LEFT([ArchiveID],8)AS Date...

thank you for helping. unfortunately that didn't work either. so then i changed it so that in the two main queries would have two fields, DocName and DocDegree. then i created a variable in the third query to concatenate them. but it still did the same thing on the report, John Doe, . so, i...

i have this variable in a query: Physician: (Staff.firstName & " " & Staff.lastName & IIf(Nz(Staff.degree),", " & Staff.degree,"")) so if firstName = John and lastName = Doe and degree = MD, the doctor name should be listed as "John Doe, MD". if the degree is null, the doctor name should be...

Perfect! Thanks so much everyone.

You're a genius LB! I was hoping you would respond. One small problem that I'm noticing, and I don't know if there is a way around this, but some of the detail sections are suppressed when certain criteria is met. For those rows that are suppressed, they are still being counted. For example...

Thanks Ian. I have placed it in each section, but it doesn't evaluate 20 times. It only increments one time for every 20 rows.

I'm trying to get a row count using the below formula. My problem is that it only increments at the next record, but the next record isn't the next row. I am using 20 detail sections. In each section I have added the same formula. The data I am pulling is patient lab results. The client...

I agree. Unfortunately, it's not our program, so we can't make any changes to the tables. Thank you for your help. I was able to get it working by using the table.field syntax like you said.

RecordNumber will create a different number for each record in your query so they won't be the same. Another way is to create two formulas like as below. add this formula to the page header: whileprintingrecords; numbervar uniqueid := 0; add this to the detail section: whileprintingrecords...

There is a function in Crystal called RecordNumber that you can use to uniquely number each record. This may work for you.

ok, I've started adding more data to my query, and now I've hit another wall. SELECT Panel.abbreviation, Panel.name, Panel.orchardName AS test_num, Concatenate("SELECT code & ' (x' & cptCount & ')' FROM (CPT INNER JOIN Panel_CPT_Map ON CPT.cPTKey = Panel_CPT_Map.cptKey) INNER JOIN Panel ON...

Hi Shelby, What happens when you export directly to .txt? Does the width of your data excede one page?

that did it! thanks for the help!

Thanks PHV. That almost does it. The problem now is that some of the records include a single quote in the name field. For these records, I get a runtime error. I tried to get rid of the single quote using Replace(name,"'","") and Replace(name,''',''), but neither worked. Any ideas for this...

I have read faq701-4233 I created the new module, but am having more problems. Is it because I'm trying to concatenate a field that is already concatenating two fields from two tables? original code: SELECT Panel.abbreviation, Panel.name, CPT.code & " (x" & Panel_CPT_Map.cptCount & ")" AS...

Here is the SQL query. There's nothing in the database to indicate which data is incorrect, which is why I would like the query to return all related records so the user can determine which is correct. I'm considering the three identifiers to be SITE, PATIENT AND DOB. If records exist with at...

I need to create a query that compares multiple records in the same table. Below are examples of the data I am looking to compare. In the first list, you can see that one of the records has a different DOB. In the second list, you can see that one of the PATIENT numbers is different. I want...