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!

  • 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: *

  1. smibarb

    Simple calulation has unexpected results

    This seems to work: 2*(Round ({#SD},2)) Despite the fact that increasing the number of decimal places in the {#SD} field did not show evidence of this, there must be trailing digits that are being considered in the calculation. Thank you for your thoughts.
  2. smibarb

    Simple calulation has unexpected results

    Sorry, not sure what you mean by rounding field. If you are referring to the number of decimals specified on the number tab for the field format, it is two, and on the same tab, 'Allow Field Clipping' is not selected (and field clipping is not what I am experiencing, and the same problem exists...
  3. smibarb

    Simple calulation has unexpected results

    Using a simple formula with unexpected results: 2*{#SD} {#SD}= 0.01, so 2*0.01 should equal 0.02, but returning 0.03 (?) I am guessing this has to do with the calculation considering than the number of displayed decimal places, but even if I increase the field to show four decimal places, the...
  4. smibarb

    Linking tables

    Thank you to both, but I am still not getting the desired results. abcmstr, removing the Select Expert criteria returns all instruments in the bu_t table, and as soon as I add a criteria from the rslt_p_t, the two meters that do not appear in this table are excluded from the report. lbass, I...
  5. smibarb

    Linking tables

    I am building a simple report that uses a left outer join to link instrument table (bu_t) to result table (rslt_pat_t). I am not getting the expected results. I expect to get every instrument regardless of whether there are results assoicated with that instrument or not. I am only getting...
  6. smibarb

    Extracting unknown number of characters

    Perfect! Thanks to both of you.
  7. smibarb

    Extracting unknown number of characters

    This sounds exactly what I need, but I am not an advanced user and this function is new to me. I cannot find further explanation in Crystal Help. When I attempt to create the formula field using: stringvar x := split({Submitter_Rev_1.Address3}," "); if ubound(x) = 5 then x[1]+" "+x[2]+" "+...
  8. smibarb

    Extracting unknown number of characters

    I am trying to clean up a database where many components of address were entered into one field. The field contains CITY PROVINCE POSTAL CODE. The city may be any number of characters, the province is always 2 letters and the postal code 6. I was able to break out the province and postal code...
  9. smibarb

    Novice wants a more descriptive error message

    Thanks lameid but even removing the <> did not seem to work, I got a compile error. However, good news! My colleague read TheAceMan1 post and was able to tweak it and make it work for our application. Thanks again to everyone for suggestions and to TheAceMan1 for our solution! Option...
  10. smibarb

    Novice wants a more descriptive error message

    Thank you to all for your replies, but I have not been able to achieve anything except errors - did I mention I am a novice and not a programmer? [dazed] I want users to be able to use this form to add records that cannot be duplicated. From our users' point of view, after adding a record they...
  11. smibarb

    Novice wants a more descriptive error message

    Please note: I am NOT familiar with VBA so any replies please talk as much as possible in layman terminology. Thank you! [dazed] I have created a simple form to add data to a table. I have added two buttons, a "next" button and a "exit" button. When a user tries to enter a duplicate value in...
  12. smibarb

    Selecting fields

    Same thing, I get the right click menu, but the field or text box does not highlight.
  13. smibarb

    Selecting fields

    This is such a minor problem but so frustrating. I am working on a new workstation and on this workstation I cannot select a field or text object by simply clicking on it and highlighting it. The fields/text objects do not highlight and instead the cursor, as soon as you move it over the...
  14. smibarb

    Table join issue

    I have a simple report in which instrument serial numbers are listed if they meet a certain criteria. 501 numbers are listed from a much longer list. I then added a table which has results for these instruments linked by the serial number. I used a left outer join. It was my understanding...
  15. smibarb

    Link options

    I did successfully set up the query as you described. Prior to your last post I noticed my mistake with the MySource and had successfully created the Union All query with the 'patient' and 'control' text labels and was also able to successfully add a field that only occurred in the qc table. I...
  16. smibarb

    Link options

    Thank you, I have successfully added my number field and succeeded in adding my text labels to distinguish origin!I am very grateful for the suggestion as I have learned much in this exercise that I will be able to apply elsewhere. This will allow me to extract the information I require but it...
  17. smibarb

    Link options

    Thank you synapsevampire for your suggestion to do the Command and thank you lbass for the suggestion regarding the syntax; I am close but am still not there. However I finally "get" what this will do for me and have tested the results and am getting the expected data returned. (It is...
  18. smibarb

    Link options

    I was hoping to avoid subreports as I want to be able to manipulate and do formulas on the results. I will attempt the Command, but I am a novice so I need to ask for clarification, I must be getting the syntax wrong. I have (exactly): SELECT 'patient'MySource op_t.op_id op_t.op_name...
  19. smibarb

    Link options

    Thanks for the suggestion but I expect numerous control values and numerous patient values for each operator. What I meant by "no relationship between the patient result table and the control result table" (besides the noted relationship of the operator who performed the test) was that a...
  20. smibarb

    Link options

    I suspect what I am trying to achieve may have to do with how I link tables, but I am very weak on this topic. I have an Operator table, a table for Patient_results and a table for Control_results. Operator ID is the field linking the Operator table to the Patient table and the operator...

Part and Inventory Search

Back
Top