Formula in db results page

J

Jason S

I'm trying to use a couple db fields in a formula to display in the db
results pages. A simple formula like [monthlycharge]*[months]
Is there a way to do this so the actual formula result populates on the web
page as opposed to seeing it in HTML format? (ie =500*12)

Thanks,

Jason
 
M

Mark Fitzpatrick

You could actually do this right in the SQL that generates the result. You
could do something in the select statement such as

([monthlycharge]*[months]) as 'Result'

to take the formula and send it back as a column named result. This goes in
the normal part of the select statement where the other column names are
listed.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage
 
J

Jason S

Thanks Mark, I appreciate it.

When you say in the normal section, I assume you don't mean in "Normal Page
View".

Jason

Mark Fitzpatrick said:
You could actually do this right in the SQL that generates the result. You
could do something in the select statement such as

([monthlycharge]*[months]) as 'Result'

to take the formula and send it back as a column named result. This goes in
the normal part of the select statement where the other column names are
listed.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage

Jason S said:
I'm trying to use a couple db fields in a formula to display in the db
results pages. A simple formula like [monthlycharge]*[months]
Is there a way to do this so the actual formula result populates on the
web
page as opposed to seeing it in HTML format? (ie =500*12)

Thanks,

Jason
Click to expand...
Click to expand...
 
Top