View Single Post
  #1  
Old January 10th, 2005, 04:15 PM
Barry
external usenet poster
 
Posts: n/a
Default data source for a report

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.....