"Lori" wrote:

> 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?
> --
> Thank, Lori

"mscertified" wrote:

> 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" wrote:
>
> > 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?
> > --
> > Thank, Lori

"Lori" wrote:

> 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.
> --
> Thank, Lori
>
>
> "mscertified" wrote:
>
> > 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" wrote:
> >
> > > 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?
> > > --
> > > Thank, Lori