Data in forms, Query returning blank sheet--need help right away!

[Mindy]

I run a query each month based off several tables. All of the data is in my
tables, my "date range" in my query is also correct. I "run" the query, and
do not get anything in return....just a blank sheet. It does not give me an
error message or anything. I KNOW the data is in the tables, as I've double
checked.

Can you please let me know what I can look at to fix this?

 

[ken]

One possibility is that the parameters, if in short date format, are
being misinterpreted as arithmetical expressions rather than dates.
Declaring the parameters as DATETIME in the query should cure this.
If not try temporarily removing the date range parameters from the
query and opening it. If it still returns no rows, or returns only
some of the rows you'd expect, another possibility is that there are
no matches in one of the tables, in which case using an outer join
should be used. If this is the case and you are already using outer
joins, but the date range is defined on columns in the table on the
right side of a LEFT OUTER JOIN say then this would exclude unmatched
rows, in effect turning the join into an INNER JOIN, so a different
approach would be required, probably using a subquery.

If you can't pin down the cause of the problem post the query's SQL
here.

Ken Sheridan
Stafford, England

 

[Noëlla Gabriël]

Hi,

if you have run those queries succesfully in the past, you can check your
relations in the query. It could be that some trivial data are missing in
one of the linked tables. For instance a query giving sales results that
work fine untill you add a link to the countries table and all sales to
customers where the country isn't filled drop out of the query. In this
example you can mend this by changing the inner join to the table countries
to an outer join.
To check this: make a copy of the query and remove table by table till you
get the right result, then alter the join to the last dropped table, or fill
in the required data... . Might be worth checking out.