Query stopped producing data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database with a query that pulls data from 2 tables. The query has
requirements that one of two possible responses are in one column, and there
must be data in another column, with no data in a third. Up until July 18th
of this year, the query has pulled data from the tables just fine. After
July 18th, there is no data produced by the query, even though the data in
the tables meets the qualifications of the query. I can't see anything that
has changed in the database or in the query that would cause this, and only
this query is affected. Any suggestions?
 
If the query has not changed then the data has changed.
Perhaps something like the column which has to have no data now contains a
space instead of a null or vice versa.

If you go into your query in SQL mode, you can tinker with the WHERE clause
to find out exactly which part is failing.

Dorian
 
That was it, exactly! The forms (created by a designer, and later changed by
another party) had a drop-down menu to choose the data that went into the
column that had the two choices. Since the data in that column no longer
matched the requirement of the query, no entries past the date the form was
changed qualified.

Thanks!
 
Back
Top