DAP Formulas

[Steve]

I have DAP that draws infor from two seperate tables. Can I have a formulas
that performs a mathmatic function on one field from each table? If so how
would the construct be writted?

Thank you in advance Steve

 

[Sylvain Lafontaine]

The easiest way to do this would be to write the formula directly in the
SQL-Server Select statement.

You can also assign an expression directly to a text box in the DAP page but
it's very difficult to do so (you must add an entry for the GroupLevel in
the Data Model with the required expression as its source, assign it a name
and then use this name as the Control Source property of the text box (the
name must be enclosed in square brackets []). This is possible but not
obvious.

There is a newsgroup about DAP: m.p.a.dataaccess.pages.

 

[Steve]

Do you have the complete web address for the DAPs?

The easiest way to do this would be to write the formula directly in the
SQL-Server Select statement.

You can also assign an expression directly to a text box in the DAP page but
it's very difficult to do so (you must add an entry for the GroupLevel in
the Data Model with the required expression as its source, assign it a name
and then use this name as the Control Source property of the text box (the
name must be enclosed in square brackets []). This is possible but not
obvious.

There is a newsgroup about DAP: m.p.a.dataaccess.pages.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

I have DAP that draws infor from two seperate tables. Can I have a formulas
that performs a mathmatic function on one field from each table? If so how
would the construct be writted?

Thank you in advance Steve

 

[Sylvain Lafontaine]

The newsgroup is microsoft.public.access.dataaccess.pages .

If you cannot access it from your current account, then you may try with
Google:

http://groups.google.ca/group/microsoft.public.access.dataaccess.pages



--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

Do you have the complete web address for the DAPs?

The easiest way to do this would be to write the formula directly in the
SQL-Server Select statement.

You can also assign an expression directly to a text box in the DAP page
but
it's very difficult to do so (you must add an entry for the GroupLevel in
the Data Model with the required expression as its source, assign it a
name
and then use this name as the Control Source property of the text box
(the
name must be enclosed in square brackets []). This is possible but not
obvious.

There is a newsgroup about DAP: m.p.a.dataaccess.pages.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

I have DAP that draws infor from two seperate tables. Can I have a
formulas
that performs a mathmatic function on one field from each table? If so
how
would the construct be writted?

Thank you in advance Steve