Add calculated query field to a Userform

(0) Share

Report

Posted on by Community Member

Hi,

Is it possible to, after creating a custom query that has a calculated field (i.e. the sum of the QtyOrdered on the SalesLine table), add that field into a grid of a new userform?

I have tried that, but only when I drag a field from the existing field list of SalesLine table the field adding works... when I try to drag that specific calculated field onto the userform Grid, it doesn't let me add it...

Is what I am trying to do not possible? And if so, If I am trying to get a sum of something, how can I show it on a userform?

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

that is absolutely possible. but your sum must be based on any Group(ing)

you can create query as specified in this thread.

then after creating query you have two options

1) drag that query directly to any form and use it

or

create a view based on your query and use it that view as DS of form

Was this reply helpful? Yes No