Data shows in query but not report

[Guest]

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?

 

[Guest]

I dont know anything about 'autoreports' as I have never used one. Why don't
you just create a report based on the query?

-Dorian

 

[Lori]

Auto report simply automatically sets up the report based on the query. It
is just a fast way to create a simple report...so yes to answer your question
this report is based on the query. That is why I need help.

 

[gls858]

Auto report simply automatically sets up the report based on the query. It
is just a fast way to create a simple report...so yes to answer your question
this report is based on the query. That is why I need help.

Does that field show in the design view for the report? It sounds like
the field was not added to the report.

gls858

 

[Lori]

yes I selected it from the field list directly several times

 

[Linq Adams via AccessMonster.com]

What version of Access and what service pack are you running?

 

[gls858]

yes I selected it from the field list directly several times

This is a long shot but is the small box checked on the show line of the
query? Also in a totals query the where function on the group by line
will not display.

gls858