View Single Post
  #1  
Old May 7th, 2010, 08:54 PM posted to microsoft.public.access.reports
Ray C
external usenet poster
 
Posts: 215
Default Report showing #Error on a valid SQL View

I have an Access app with an SQL Server backend.
One report is based on a VIEW. When I run the view alone all the data is
visible. But when I run the report, I get #Error on one field. The field is
numeric. However, the RecordSource property of the textbox is:

[MyNumericFieldFromSQLView]/32

What's strange is that when I remove the division by 32, the #Error
disappears.
What I need to do in the report is divide the value from the view by 32. I
cannot modify the view because it is not an option.

Any help? Thanks !