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.

[orange]

Show us the query sql.

[Heatshiver]

Here is from the Query where it works (all one table):

SELECT [All].Days, [All].[Mud Flow Line Temp], [All].[Mud Pit Temp], [All].[Mud In to HE Temp], [All].[Mud Out of HE Temp], [All].[LGS%], [All].[Mud Weight], [All].[Oil Water Ratio]
FROM [All]
WHERE ((([All].Days) Between [Start Date] And [End Date]));

Here is from two tables that won't work:

SELECT [All].Days AS All_Days, [Centrifuge #1].[LGS lb/hr], [Centrifuge #1].[HGS lbs/hr], [Centrifuge #1].[Hours Run], [Centrifuge #1].[Mt Tons LGS], [Centrifuge #1].[Mt Tons HGS], [Centrifuge #1].[Total Mt Tons], [Centrifuge #1].[Feed PPG], [Centrifuge #1].[Feed GPM], [Centrifuge #1].[Centrate PPG], [Centrifuge #1].[Centrate GPM], [Centrifuge #1].[Solids PPG], [Centrifuge #1].[Solids GPM], [Centrifuge #1].[Mud Discharge], [Centrifuge #1].[NAF Discharge], [Centrifuge #1].[Total Volume Discharge bbl], [Centrifuge #1].[Average OOC%], [Centrifuge #1].[Average Specific Gravity Solids]
FROM [All] INNER JOIN [Centrifuge #1] ON [All].[Days] = [Centrifuge #1].[Days]
WHERE ((([All].Days) Between [Start Date] And [End Date]));


It seems like it has to do with my relationships. They are inner joins to one table...

[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?