If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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..... |
#2
|
|||
|
|||
I believe the query is "hidden". Select Tools-Options-View and check
Hidden objects. -- Duane Hookom MS Access MVP "Barry" wrote in message ... 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..... |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data not being display in Access Report via an ODBC Connection | David S | General Discussion | 0 | November 4th, 2004 04:19 AM |
Data Source issues | Philippe | Database Design | 1 | October 10th, 2004 09:45 PM |
SQL view of messed up action queries | Kendra | Running & Setting Up Queries | 2 | August 31st, 2004 09:53 PM |
Chart Source Data Ranges Changing when Data Sheet updated from text file source. | Tekn0 | Charts and Charting | 3 | January 8th, 2004 05:45 PM |