I calculate expression (it adds)

valdemirjs

As I should proceed to add 3 columns in a memo...
I already tried
QRY. VLR_P " ]+ [QRY. VLR_R " ]+ [QRY. VLR_V "
and
[QRY. " VLR_P"+ QRY. " VLR_R"+ QRY. VLR_V "]
but I didn't get

gordk

hi
unless this was a typo
QRY. VLR_P " ]+ [QRY. VLR_R " ]+ [QRY. VLR_V "
shpold be
QRY. "VLR_P " ]+ [QRY. "VLR_R " ]+ [QRY. "VLR_V "
regards

valdemirjs

gordk wrote:

hi
unless this was a typo
QRY. VLR_P " ]+ [QRY. VLR_R " ]+ [QRY. VLR_V "
shpold be
QRY. "VLR_P " ]+ [QRY. "VLR_R " ]+ [QRY. "VLR_V "
regards

Hello...
I used Copy/Paste and I didn't notice that it didn't come the quotation marks.
In the project I tried with the quotation marks...

[QRY. VLR_P " + QRY. VLR_R " + QRY. VLR_V "]

but it presents the following error message

EVarianteTypeCastError: 'Could not Convert variante of type (string) into type (double).

oh I tried

[FormatFload('000,000,000.00',[qry."VLR_P" + qry."VLR_R" + qry."VLR_V"])]

but oh he/she doesn't give mistake, but it doesn't also print anything

gordk

Hi
try building you expression using the expression builder
it will get your brackets correct for you.
to retreive the value of a data field it must be enclosed in square [] brackets.
ie sum of fields across row displayed in memo at right of the row
table1."fieldname1"] + [table1."fieldname2"] + [table1."fieldname3"
regards