Hi,

I did a query to so I could do a report to list all our companies bank
accounts and  numbers.  When I run the query all the data shows up fine.  But
when I do an autoreport - tabular, the bank name does not show up.  It is the
only data that doesn't.  Here is the SQL view of my query:

SELECT tblBlueBookCompanies.CompanyName, tblFinancialInstitutions.Bank,
tblFinancialInstitutions.BankAccountType,
tblFinancialInstitutions.BankAccountNumber
FROM tblBlueBookCompanies INNER JOIN tblFinancialInstitutions ON
tblBlueBookCompanies.FederalID = tblFinancialInstitutions.FederalID
WHERE (((tblFinancialInstitutions.ActiveInActive)=True))
ORDER BY tblBlueBookCompanies.CompanyName;

I don't understand how it can show up on the query, but not the report?  Can
anyone help with this one?