FreePint: Join
Join FreePint and receive the Newsletter every two weeks for free.
Join now »
|
My Account »
|
|
If you find FreePint useful, please supply
a testimonial »
|
|
FreePint Family:
Monthly magazine reviewing business information products »
Articles, tools, and a monthly magazine, to give you practical help with information skills »
Recruit for information-related roles, or find your next challenge. »
Daily update of web-based resources »
Daily update of free, full-text reports »
|
|
|
|
Home > Forum > Bar > Message |
|
|
Join FreePint and receive the twice-weekly Bar Digest and twice-monthly tip-packed Newsletter. It's free. [ more ]
|
|
|
|
The FreePint Bar is generously sponsored by Dow Jones Factiva.
|
|
|
| Start New | Message Index | Flat View |
| Access 97 Reports |
| Author: | Suz |
| Date: | Wednesday, 11th Jul 2001 14:27 |
| Views: | 3,635 (excluding Digests and RSS feeds) |
| Category: | Computers and Software | | URL: | http://www.freepint.com/go/b11174 |
|
I am trying to generate a report based on several queries that perform calculations. The primary source of data that I flagged when creating the report reproduced the figures I wanted shown accurately. However, when I try to then add text boxes with the Control Source then pointing to the other relevant queries, depending on the syntax I use I get one or more of the following;
1. A blank text box
2. A prompt to enter a parameter value (not needed when I run the queries independently)
3. A text box showing #Error? or #Name? (informative Microsoft errors once again!!)
Looking into the help files I've found I can't add calculated fields to reports from queries, so I tried making the queries 'make table' queries so the data was from a defined source, no luck. An example of what I'm doing follows;
Data source is Queries![Suz_HBS 2001 Adhoc]![No Sold]
I have tried various combinations including having the control source show the following;
=Sum[Suz_HBS 2001 Adhoc]![No Sold] and many different variations on that, what am I missing??
I know this must be easy but it's really got me stumped. Many thanks for any help.
Suz
|
|
| Start New | |
| Topic |
Author |
Date |
ID |
 | Access 97 Reports | | I am trying to generate a report based on several queries that perform calculations. The primary source of data ... |
|
Suz |
11/07/01 14:27 |
11174 |
|
Helen Bilton |
13/07/01 10:25 |
11213 |
 | Re: Access 97 Reports | | Helen, many thanks, subreports was exactly what I ended up doing, all 8 of them as I wasn't able to ... |
|
Suz |
16/07/01 12:43 |
11255 |
Please note: The reply form is not showing because the posting is older than six months or the thread is locked. Please start a new topic or contact the forum administrator.
|
|
