L
Lori
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?
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?