A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

data source for a report



 
 
Thread Tools Display Modes
  #1  
Old January 10th, 2005, 05: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.....
  #2  
Old January 10th, 2005, 08:01 PM
Duane Hookom
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 12:52 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.