blank records in query results

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
I managed to fix this.

The Row Source for Element in my form was loading:
SELECT [Elements].[ID ], [Elements].[Element] FROM [Elements]

Thus, loading the ID column first and saving this field in the Results
table. I simply amended this to:
SELECT [Elements].[Element] FROM [Elements]

I still don't know why it was giving me blnk entries in the query, at least
it should have given me the Primary Key values.

D Dawson
 
Back
Top