Views returning incorrect data

Hi
I've noticed this problem a few times. I'm using SQL 2000, with an ADP
report based on a view. One of the report text boxes will display incorrect
data.
For example, yesterday the BuildingHeight was on the report was 10. When I
check the report, it showed 2. If I check the Buildings table, the value is
10. But if I open the view, the value is 2. If I then make a change to the
view (remove/add a field), the data will now be correct.

I think this happens after I change tables that the view is based on. Does
indicate something else in the database is incorrect? Any recommendations?

Thanks
Vayse


.

Relevant Pages

  • Re: Parameter query with multiple check boxes
    ... Does the report get the info from the query which gets info ... "Duane Hookom" wrote: ... assuming you have check boxes on your criteria form and the ...
    (microsoft.public.access.queries)
  • Re: Clear and Requery combo boxes
    ... Q1 - I would put the code to clear the combo boxes after the code that calls ... the report and before the code that makes form visible again. ... > The choices then generate a report based on the selection. ... > Exit Sub ...
    (microsoft.public.access.formscoding)
  • Re: SELECT Statement in a Report
    ... I created a Select Query using these two tables. ... The problem is getting the text boxes in the detail section to work. ... Report Footer Section). ...
    (microsoft.public.access.reports)
  • Re: Query by Form
    ... Dim strWhere as String ... >> Combo Boxes. ... >> form which enables the user to run the report. ... >>> on the form are text boxes for all of the criteria. ...
    (microsoft.public.access.queries)
  • RE: Query by Form
    ... form which enables the user to run the report. ... boxes, the report/query will view the criteria as " ", rather then *. ... > which query based on which check box was checked. ...
    (microsoft.public.access.queries)