Getting no results in query (screenshot)

[xcmav66]

I'm having trouble with this query that I've built. As far as I can tell, I'm not running into any data type mismatches or anything, but it is returning zero records when I run it. Am I doing something wrong with the joins? All this is is a query to display some data about the productivity of these employees. Any help would be appreciated, ask if you have questions about the data etc...thanks.

 

[Rabbie]

Looking at your picture it is not possible to be sure what is going on but I can only see group by fields and no result fields. What are you actually trying to acheive with this query?

 

[Access_guy49]

Is it safe to assume that the data is complete for all fields that are linked, or do some tables have blank data in their linking fields?

 

[xcmav66]

Basically what i'm trying to do is filter down hundreds of thousands of records pertaining to parts on our shop floor into just a couple thousand by using the linking between the tables. Each part in the SVS_DB_VOUCHER table is linked to an employee by his badge/payno. For each master router id, there are multiple sequence numbers, all of which are stored in CFG_RTR_SEQUENCE. We want to link the master router id and sequence number for each individual part in SVS_DB_VOUCHER into the more generic data in CFG_RTR_SEQUENCE. Does this help?

 

[xcmav66]

Is it safe to assume that the data is complete for all fields that are linked, or do some tables have blank data in their linking fields?

All of the linked fields in all of the tables have data for at least some, if not all records. If i'm not mistaken the results should just pick up on the records with data correct? This is what I want.

 

[Access_guy49]

With the way the relationships are set up at default, Access will look for records where there is a match in both tables.

Example time:

Table 1, Table 2 and Table 3. Each are linked via an ID field. lets say all tables have 1,2 and 3, making 3 records for each table.
If tables 1, 2 and 3, all have an ID of 1. then the 1 record will be retrieved.
If tables 1 and 2 have an id of 2 but table 3 does not. the record will not be retrieved.

right click on your relationships (the line) click edit relationship and click on the join type button. The options explain, and it should be able to help you get what you want.