Number format in table does not carry over into data access page

[thebluffer]

I have created an DataAccessPage but all numbers carry over from my source tables unformatted. I can use the =CCur() function in the control source to format currancy. I also have incorporated FormatNumber() and FormatPercent() for other number formats needed. However, when I try to open the page in my browser I get an error message

"Column (FormatNumber) was used in a CALC expression but is not defined in the rowset".

I have no idea what to do. Thanks for any assisance.

 

[binoculars]

I get the message COLUMN (_____PARAM:: was used in a calc expression but it is not defined in the rowset.

This message comes up when i try to open an accesreport. The accessreport is connecten to a stored procedure wich asks for an inputparameter.

The stored procedure itself works fine. I wonder what it is