Fai la tua domanda

speakerender1's profile - attività

2020-05-16 20:17:04 +0200 received badge  Domande famose (source)
2019-05-25 17:17:18 +0200 received badge  Domande famose (source)
2019-01-02 21:07:24 +0200 received badge  Domanda notevole (source)
2018-10-17 03:10:29 +0200 received badge  Entusiasta
2018-10-12 02:56:52 +0200 ha commentato una risposta SQL Query How to write SQL to acomplish different things in a form?

Maybe what I meant was the Form Content was the Query as opposed to being a table. The Query still references the table

2018-10-12 02:16:33 +0200 ha commentato una risposta SQL Query How to write SQL to acomplish different things in a form?

I'm looking that handbook over and reading over information on planning out a database. Most resources I see are tellin

2018-10-08 23:42:37 +0200 received badge  Sostenitore (source)
2018-10-08 23:41:58 +0200 ha accettato una risposta SQL Query How to write SQL to acomplish different things in a form?

image description

image description

I have a form that takes user inputs in the test point and observed columns and finds the percentage difference between the two. I'm trying to display in the Pass/Fail Text box a Pass or a Fail depending on if any of the %differences are higher than the allowed repeatability. I'm having difficulty putting that code into the existing code. I always seem to get syntax errors when adding additional code. It seems like I might need to make multiple queries however the Form itself is created from a query so I'm not sure what the best way to go about adding additional SQL code to the existing.

EDIT: Sure I added a copy of what I have. Thanks for the help. The existing SQL code I have is included in the picture. The additional code I thought might solve the problem I put in the text below. I was getting basic syntax errors. I was just trying to put my additional SQL code in the one line created in the query design view. The pass fail on the left below the 10 % Difference columns should be calculated by comparing the % difference for each of the ten columns against the user inputted allowed repeatability if anyone of the % difference columns is higher than the allowed repeatability it should display fail, if they are all within the % error it should display pass.

EDIT2: Sorry for any confusion. Below underlined in yellow is the text box where a user can input the allowed repeatability. The red underline is where the pass or fail goes. In order to determine the pass and fail. Each of the numbers within the blue box will be compared individually to the repeatability (yellow). If any one of the numbers in the blue box is higher than the yellow it should display Fail if all are below it should display Pass.

image description

UPDATE TableName SET PassAF = (CASE WHEN DIFAF1 > AllowRepeatErr THEN "Pass" ELSE "

Copy of the file C:\fakepath\Measurementsbackup.odb

2018-10-08 23:23:16 +0200 ha commentato una risposta SQL Query How to write SQL to acomplish different things in a form?

I'm very new to databases and to Libreoffice Base so I appreciate the Guidance. I think I will start over and take you

2018-10-08 23:23:05 +0200 ha commentato una risposta SQL Query How to write SQL to acomplish different things in a form?

Thank you very much. I'm very new to databases and to Libreoffice Base so I appreciate the Guidance. I think I will st

2018-10-08 23:01:48 +0200 received badge  Domanda gettonata (source)
2018-10-08 21:39:34 +0200 ha modificato una domanda SQL Query How to write SQL to acomplish different things in a form?

SQL Query How to write SQL to acomplish different things in a form? I have a form that takes user inputs in the test

2018-10-08 20:51:12 +0200 ha modificato una domanda SQL Query How to write SQL to acomplish different things in a form?

SQL Query How to write SQL to acomplish different things in a form? I have a form that takes user inputs in the test

2018-10-08 20:44:00 +0200 ha commentato una domanda SQL Query How to write SQL to acomplish different things in a form?

The code I intend to add (hopefully it will work) UPDATE "Measurement Input" ###Table name SET PassAF = (CASE WHEN DIFA

2018-10-08 20:41:10 +0200 ha commentato una domanda SQL Query How to write SQL to acomplish different things in a form?

posted above

2018-10-08 20:40:58 +0200 ha modificato una domanda SQL Query How to write SQL to acomplish different things in a form?

SQL Query How to write SQL to acomplish different things in a form? I have a form that takes user inputs in the test

2018-10-08 20:40:58 +0200 received badge  Revisore (source)
2018-10-08 20:38:37 +0200 ha commentato una domanda SQL Query How to write SQL to acomplish different things in a form?

Sure I added a copy of what I have. Thanks for the help. The existing SQL code I have is included in the picture. The

2018-10-08 20:33:17 +0200 ha commentato una domanda SQL Query How to write SQL to acomplish different things in a form?

Sure I added a copy of what I have. Thanks for the help.

2018-10-08 20:32:38 +0200 ha modificato una domanda SQL Query How to write SQL to acomplish different things in a form?

SQL Query How to write SQL to acomplish different things in a form? I have a form that takes user inputs in the test

2018-10-08 18:28:22 +0200 ha posto una domanda SQL Query How to write SQL to acomplish different things in a form?

SQL Query How to write SQL to acomplish different things in a form? I have a form that takes user inputs in the test

2018-10-05 21:56:56 +0200 received badge  Domanda notevole (source)
2018-10-05 03:48:45 +0200 received badge  Domanda gettonata (source)
2018-10-05 01:04:36 +0200 ha accettato una risposta Displaying sum of two text input boxes into third box

image description

Trying to find the best way to take user input from the test point box and observed box and run mathematical calculations between the two numbers and display it in the % difference text box. I thought it might be able to be done through query but It doesn't seem to update automatically. I was hoping to have the % difference box update automatically once the other two input boxes are filled. Any advice would be much appreciated.

2018-10-05 01:04:36 +0200 received badge  Studioso (source)
2018-10-04 23:01:32 +0200 ha posto una domanda Displaying sum of two text input boxes into third box

Displaying sum of two text input boxes into third box Trying to find the best way to take user input from the test poi