Novice
Windows 10 
Access 2013 64bit
Boa noite
Valor02: SeImed([Valor01]>0;[Valor01];(0) 'onde está o meu erro?
Não estou conseguindo executar minha consulta csValorMoeda , são várias colunas calculadas.
Como fórmulas para essas colunas estão descritas na Tabela ValorMoeda , modo Design, Descrição Opcional.
[ANEXO] 41687 [/ ANEXO] [ANEXO] 41687 [/ ANEXO]
BD no anexo
Grato desde já!
Last edited by Zaccariotto; 04-27-2020 at 06:36 AM.
Virtually Inert Person
Windows 10 Access 2016
Google translation (apparently from Portuguese)
Zaccariotto, let us know if you cannot do the translation. I think you will not get many answers if your posts are not in English.good evening
Value02: SeImed ([Value01]> 0; [Value01]; (0) 'where is my error?
I am unable to execute my csValorMoeda query, there are several calculated columns.
As formulas for these columns are described in the CurrencyValue table, Design mode, Optional Description.
[ANNEX] 41687 [/ ANNEX] [ANNEX] 41687 [/ ANNEX]
Perhaps the translation I made is not so good - I have no idea what "SeImed" means. The expression you posted looks a bit like an IIF function.
Your problem may be ";" because commas (,) are usually separators in functions.
I did not look at your database because I suspect I will not be able to read any of it.
You should always provide an error number and error message if you are getting one.
Last edited by Micron; 04-27-2020 at 09:06 AM. Reason: added info
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Novice
Windows 10 Access 2013 64bit
exato selecionado seria o mesmo que se
Simple table relationships ("faces" to "spaces" to "chairs")
Login to Access as "Admin" or "User" allowing different Editing, Additions and Deletions permission
Posting Permissions
Reply With Quote