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.
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...
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...
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...
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...
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]+" "+...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.