Haz tu Pregunta

perfil de Panchopar - actividad

2021-01-31 10:27:21 +0200 recibió una medalla  Pregunta Notable (fuente)
2020-10-31 22:40:45 +0200 recibió una medalla  Pregunta Famosa (fuente)
2020-10-31 07:37:45 +0200 comentar respuesta how to take the results of a calulation (alias) and store it into a field in a table

I am doing this for every new record entered. (Trying to do it), I am using mysql as my backend and Libre office base a

2020-10-31 07:13:43 +0200 comentar respuesta how to take the results of a calulation (alias) and store it into a field in a table

I am doing this for every new record entered. (Trying to do it), I am using my Sal as my backend and Libre office base

2020-10-31 07:13:43 +0200 recibió una medalla  Comentador
2020-10-31 06:58:57 +0200 comentar respuesta how to use the total of a sum function as part of another calulation in libreoffice base

Will try that. Thanks for the help

2020-10-30 23:45:45 +0200 recibió una medalla  Pregunta Notable (fuente)
2020-10-30 16:55:20 +0200 recibió una medalla  Pregunta Popular (fuente)
2020-10-30 04:55:52 +0200 realizó una pregunta how to take the results of a calulation (alias) and store it into a field in a table

how to take the results of a calulation (alias) and store it into a field in a table I want to know how to take the resu

2020-10-29 04:09:19 +0200 comentar pregunta how to use the total of a sum function as part of another calulation in libreoffice base

yes the query works fine but when I try to add a calculation using the alias it says can't find that field.

2020-10-29 00:35:34 +0200 recibió una medalla  Pregunta Famosa (fuente)
2020-10-29 00:21:46 +0200 recibió una medalla  Pregunta Famosa (fuente)
2020-10-27 05:05:55 +0200 comentar pregunta how to use the total of a sum function as part of another calulation in libreoffice base

stotal is the alias for the sum of the amount. total is another field in cusinv table.

2020-10-25 00:22:11 +0200 recibió una medalla  Pregunta Notable (fuente)
2020-10-24 09:58:15 +0200 recibió una medalla  Pregunta Popular (fuente)
2020-10-23 23:56:22 +0200 comentar pregunta how to use the total of a sum function as part of another calulation in libreoffice base

SELECT "cusinfo"."cnum", "cusinv"."invnum", SUM( "invitem"."amount" ) "stotal", "total" - "ourcost" - "shipcost" - "

2020-10-23 23:55:45 +0200 comentar pregunta how to use the total of a sum function as part of another calulation in libreoffice base

SELECT "cusinfo"."cnum", "cusinv"."invnum", SUM( "invitem"."amount" ) "stotal", "total" - "ourcost" - "shipcost" - "

2020-10-23 18:38:02 +0200 comentar pregunta how to use the total of a sum function as part of another calulation in libreoffice base

SELECT "cusinfo"."cnum", "cusinv"."invnum", SUM( "invitem"."amount" ) "stotal", "total" - "ourcost" - "shipcost" - "mota

2020-10-23 12:09:14 +0200 recibió una medalla  Pregunta Popular (fuente)
2020-10-22 23:00:28 +0200 comentar pregunta how to use the total of a sum function as part of another calulation in libreoffice base

I can get the total sum but it is a alias and it won't let me use alias fields as a part of a calculation.

2020-10-22 22:58:30 +0200 comentar pregunta how to use the total of a sum function as part of another calulation in libreoffice base

I am using a query on my form to show me the sum of the amount field in one of my tables. Form has 5 tables on it. This

2020-10-22 22:45:49 +0200 recibió una medalla  Estudiante (fuente)
2020-10-22 22:25:48 +0200 realizó una pregunta how to use the total of a sum function as part of another calulation in libreoffice base

how to use the total of a sum function as part of another calulation in libreoffice base how to use the total of a sum f

2020-10-22 19:34:13 +0200 realizó una pregunta Why can I only search my main form in a form that has 1 main and 4 sub forms?

Why can I only search my main form in a form that has 1 main and 4 sub forms? Why can I only search my main form in a fo

2020-07-16 00:13:13 +0200 recibió una medalla  Entusiasta
2020-07-12 20:42:51 +0200 la mejor respuesta fue marcada Can I create a form in base with more than one page?

I want to create a 2 page form for libreoffice base. Is that possible and how

2020-07-12 20:42:51 +0200 recibió una medalla  Escolar (fuente)
2020-07-12 20:42:05 +0200 comentar respuesta Can I create a form in base with more than one page?

thanks I changed the page format to 8.8 to 14 and all seems to work as I wanted it to. Thank to all.

2020-07-12 05:34:26 +0200 recibió una medalla  Pregunta Notable (fuente)
2020-07-11 22:44:03 +0200 recibió una medalla  Pregunta Popular (fuente)
2020-07-11 22:32:38 +0200 comentar respuesta Can I create a form in base with more than one page?

I don't want to use 2 Forms just a second page on the one and only form. Can I format the form page to use more space .

2020-07-11 21:13:33 +0200 comentar pregunta Can I create a form in base with more than one page?

I am using Msql on a ubuntu server. Using windows 10 with libreoffice 6.3 base connecting direct to the server on same

2020-07-11 19:24:44 +0200 realizó una pregunta Can I create a form in base with more than one page?

Can I create a form in base with more than one page? I want to create a 2 page form for libreoffice base. Is that possi

2020-02-19 20:50:42 +0200 recibió una medalla  Pregunta Famosa (fuente)
2019-11-30 17:47:14 +0200 recibió una medalla  Pregunta Notable (fuente)
2019-11-28 01:54:25 +0200 recibió una medalla  Pregunta Popular (fuente)