N
ngan
I have Access XP FE and SQL 2k BE.
For the past few weeks, one report has been running just
fine....but then yesterday, the person who prints it out
noticed an anomaly.
Here is what the report does:
I have two tables, complaint and response. The report
looks at a query where it lists all the complaints and
response in a LEFT JOIN (complaint -> response). The
criteria looks at two fields in the response table,
ResponseReadyDate (is not null) and ResolutionDate (is
null).
Yesterday's printout of the report listed complaints that
didn't have responses. When I ran it today, those didn't
show up. I haven't been able to recreate the anomaly. I
don't know how those complaints would have shown up
because my criteria asks for ResponseReadyDate that is not
null. If those complaints never had a response record,
the dates would be null.
Anyone dealt with this before?
For the past few weeks, one report has been running just
fine....but then yesterday, the person who prints it out
noticed an anomaly.
Here is what the report does:
I have two tables, complaint and response. The report
looks at a query where it lists all the complaints and
response in a LEFT JOIN (complaint -> response). The
criteria looks at two fields in the response table,
ResponseReadyDate (is not null) and ResolutionDate (is
null).
Yesterday's printout of the report listed complaints that
didn't have responses. When I ran it today, those didn't
show up. I haven't been able to recreate the anomaly. I
don't know how those complaints would have shown up
because my criteria asks for ResponseReadyDate that is not
null. If those complaints never had a response record,
the dates would be null.
Anyone dealt with this before?