空白查询结果 [英] Blank Query Results

问题描述

我需要帮助找出为什么我的查询中没有任何数据。


当我在查询网格中选择一个表中的所有字段并运行它时，数据就在那里。但是，当我尝试使用相关表并从我的查询中的两个表中拉取字段并运行查询时，来自两个相关表的数据都没有显示在我的查询数据表中。问题是什么？我的查询中的关系行显示该表已链接。


感谢您提前回复。

I need help in finding out why I am not getting any data in my query.

When I select all the fields in one table in my query grid and run it, the data is there. However, when I try to do it using to related tables and pull fields from both table in my query rid and run the query, data from both related tables are not showing in my query datasheet. What is the problem? The relationship line in my query is showing that the table are linked.

Thanks for your response in advance.

推荐答案

关系行意味着您正在对链接字段进行内部联接，因此只会显示两个表中这些字段中相同的记录。

The relationship line means you are doing an inner join on the linked field, so only records that are equal in those fields from both tables will be shown.

@ChipR


感谢您的回复。


PS我在字段中有足够的数据，有些是空字段。当我运行查询并添加我的标准时，数据仍应显示在我的查询数据表中。它没有这样做。

@ChipR

Thanks for responding.

P.S. I have enough data in the fields and some are null fields. When I run the query and adding my criterias, the data should still show in my query datasheet. It is not doing it.

您是否首先运行查询而没有标准来验证您是否有一些记录要应用这些条件？

Did you run the query first without the criteria to verify that you have some records to apply the criteria to?

这篇关于空白查询结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！