J
JimS
I have a table (actually a query) joined to 5 other tables (mostly queries)
by two keys: ProjectID, and EquipmentID. While ProjectID cannot be null,
EquipmentID can.
The primary (driver) table contains a list of all project/equipment
combinations that are possible, including projects with null equipment IDs.
The other tables (queries) have summarized spending for a given
Project/equipment pair. There are several different categories of spending,
and my client wants them on one line (like a crosstab query).
It appears that if the driver equipmentID is null, it matches nothing.
Suggestions?
by two keys: ProjectID, and EquipmentID. While ProjectID cannot be null,
EquipmentID can.
The primary (driver) table contains a list of all project/equipment
combinations that are possible, including projects with null equipment IDs.
The other tables (queries) have summarized spending for a given
Project/equipment pair. There are several different categories of spending,
and my client wants them on one line (like a crosstab query).
It appears that if the driver equipmentID is null, it matches nothing.
Suggestions?