G
Guest
I am trying to produce reports from my database but the query is producing
blank results. I'm new at this!
My database records building survey data according to the condition of each
building element i.e. structure, external fabric, internal fabric, etc.
I have produced the following related tables: LocationsAndDate,
ListOfElements, ConditionReferences, Results. The listofElement table has
Primary key, Element ref, and Description - columns, Likewise
ConditionReferences table has Primary key, Condition ref, and Description -
columns.
I have set up relationships so that everything is pulled together into the
Results table. But, the Element and Condition entries in the results table
are the Primary Key values for the value selected in the form. This is how it
should be, is it not?
When I try to create a query for my report; where the column contains
PrimaryKey Data, the query results are blank. Also, I do not want to show the
primary key results in my report, but rather, the actual values of Element
and Condition.
blank results. I'm new at this!
My database records building survey data according to the condition of each
building element i.e. structure, external fabric, internal fabric, etc.
I have produced the following related tables: LocationsAndDate,
ListOfElements, ConditionReferences, Results. The listofElement table has
Primary key, Element ref, and Description - columns, Likewise
ConditionReferences table has Primary key, Condition ref, and Description -
columns.
I have set up relationships so that everything is pulled together into the
Results table. But, the Element and Condition entries in the results table
are the Primary Key values for the value selected in the form. This is how it
should be, is it not?
When I try to create a query for my report; where the column contains
PrimaryKey Data, the query results are blank. Also, I do not want to show the
primary key results in my report, but rather, the actual values of Element
and Condition.