Query Won't Return Valid Parameter! Possibly Simple Fix.

[Heatshiver]

I have four tables all related by date. I want to create a simple query that asks for a start date and end date in order to populate a report as such.

Every time I create a query with the Wizard and include more than one table (or even more than just the "Days" field), my parameter Between [Start Date] And [End Date] won't return any values.

However, if I use the Query Wizard and put only "Days", my parameter will return values from the table(s). I then have to add all the remaining fields/tables to the query manually...

Does anyone know what might be going on?

The only thing I noticed is that if I choose just "Days" with the Query Wizard, it gives the name as [Days] in the query itself. But when I choose other fields/tables, it always appears as a different format and gives me problems.

 

[Heatshiver]

I think I may have figured it out. Without any data in one of the tables, the entire query will show no data. However, if it at least has some data (even if not for the field chosen), then it will work as expected.

Why is that?