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

    need to convert memo field into dynamic array of <=75 character strings

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

    need to convert memo field into dynamic array of <=75 character strings

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

    Use IF/ELSE in Query

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

    Use IF/ELSE in Query

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

    query variable doesn't work in report

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

    query variable doesn't work in report

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

    Actual Row Count Not Record Count

    Perfect! Thanks so much everyone.
  8. betachristopher

    Actual Row Count Not Record Count

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

    Actual Row Count Not Record Count

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

    Actual Row Count Not Record Count

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

    concatenating multiple child records into a single value

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

    formula to have it auto number

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

    formula to have it auto number

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

    concatenating multiple child records into a single value

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

    Export to ASCII

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

    concatenating multiple child records into a single value

    that did it! thanks for the help!
  17. betachristopher

    concatenating multiple child records into a single value

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

    concatenating multiple child records into a single value

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

    Compare Multiple Records

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

    Compare Multiple Records

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

Part and Inventory Search

Back
Top