Table Causes Query Problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My DB is set up as follows:

Table A has a primary key ID
Table A is related to Table B in a 1-many relationship with the ID
Table A is also related to Table C with a Status Code
Table C is the definition table to give a description for the Status Code

I am able to create a query with Table A and B, but when I add C into the
mix, I get no return in my query. I need the description of the status in my
query results.

Please help me, thanks!
 
Kojones said:
My DB is set up as follows:

Table A has a primary key ID
Table A is related to Table B in a 1-many relationship with the ID
Table A is also related to Table C with a Status Code
Table C is the definition table to give a description for the Status Code

I am able to create a query with Table A and B, but when I add C into the
mix, I get no return in my query. I need the description of the status in my
query results.

Please help me, thanks!
Click to expand...

Hi kojones,

Please post the SQL of your query.

LeAnne
 
SELECT tblAcquired_Inforce_Listing.ID, tblAcquired_Inforce_Listing.[policy#],
tblAcquired_Inforce_Listing.rider, tblStatus.StatusDesc,
[tblAcquired_Inforce_Listing]![last_name] & " " &
[tblAcquired_Inforce_Listing]![suffix] & "," & " " &
[tblAcquired_Inforce_Listing]![prefix] & " " &
[tblAcquired_Inforce_Listing]![first_name] & " " &
[tblAcquired_Inforce_Listing]![middle] AS Full_Name,
tblAcquired_Inforce_Listing.gender, tblAcquired_Inforce_Listing.issue_date1,
tblAcquired_Inforce_Listing.Comment1, tblAcquired_Inforce_Listing.Comment2,
tblTransamerica_Billings.[2003_Pymt_Date],
tblTransamerica_Billings.[2003_NAAR],
tblTransamerica_Billings.[2003_premium],
tblTransamerica_Billings.[2004_Pymt_Date],
tblTransamerica_Billings.[2004_NAAR], tblTransamerica_Billings.[2004_premium]
FROM tblStatus INNER JOIN (tblAcquired_Inforce_Listing INNER JOIN
tblTransamerica_Billings ON (tblAcquired_Inforce_Listing.ID =
tblTransamerica_Billings.ID) AND (tblAcquired_Inforce_Listing.ID =
tblTransamerica_Billings.ID)) ON tblStatus.StatusCode =
tblAcquired_Inforce_Listing.Status
WHERE
(((tblAcquired_Inforce_Listing.ID)=[Forms]![frmAcquired_Inforce_Listing]![Text63]));
 
Back
Top