CODEWITHSUNDEEP
ms-access
cona
cona

Reputation: 189

Microsoft Access Query Results are Empty

I don't understand why I'm getting empty results for my query (company name from Companies table and Shares Outstanding from Shares Outstanding table). Fields are linked (see below).

If I run the query using fields from one table only, I see results; just not when I'm pulling data from several tables.

See the below screenshots for the relationships, query setup and query results.

Relationships

Query

Datasheet View

Upvotes: 1

Views: 1076

Answers (1)

June7
June7

Reputation: 21379

Those 3 Shares tables should be 1 table with another field for share type (outstanding, short, floating)

Companies table not linking to dependent tables on key fields. Companies table ID field is designated as primary key and should be saved as foreign key in number (long integer) field in dependent table. Just as was done with Sources and Exchanges tables.

Advise not to use exact same field name in multiple tables. Also, should not use spaces nor punctuation/special characters (underscore is only exception) in naming convention.

Upvotes: 2

Related Questions