data source for a report

B

Barry

I'm trying to understand how to put data into a report. I am looking at the
Northwinds Traders sample database, specifically at the "Sales Totals by
Amount" report. When I look at this table in design view, at the properties
sheet for the whole report, I see the "Record Source" is "Sales Totals by
Amount". I thought the record source for a report had to be a table or a
query, but there is no such table or query as "Sales Totals by Amount". I
tried to create a report similar to "Sales Totals by Amount" without
creating a query, but couldn't do it. I am totally confused.

Do you need to specify a table or query, or not? If not, how is it done? Or,
am I just not seeing something that is in plain sight?

I guess the main thing is, I need to understand how the "Sales Totals by
Amount" report was created. In the past, I have found that if I skip over
this sort of question, it usually bites me later, big time.

Thanks.....
 
D

Duane Hookom

I believe the query is "hidden". Select Tools->Options->View and check
Hidden objects.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top