skip missing dates...is it possible?

[Vargasman]

i have a report that opens from a query that pulls from 8 different tables using the date as the primary key for each table. I want to be able to open my query without having to input a blank record for each date in each table. Basically I don't use every table everyday. Sometimes I just use 3-4 tables and others I will use all 8.

 

[pdx_man]

I want to be able to open my query without having to input a blank record for each date in each table.

Huh?

Basically I don't use every table everyday. Sometimes I just use 3-4 tables and others I will use all 8.

Huh?

Maybe post your query.