|
|
Exclude Duplicates in Report Counts by
bdehning
I have been struggling for days to try and figure out how to get correct counts in my report. I have a table that has primary key Policy number which is...
|
|
5 |
111 |
|
|
League Tables by
Duane Hookom
Create a query that returns one record:
SELECT TOP 1 POINTS as MaxPoints
FROM tblLeagueTable
ORDER BY POINTS DESC, TEAM;
This should return one record with...
|
July 24th, 2004 12:01 PM
by jpanon
|
4 |
215 |
|
|
Report with subreport sorting and grouping by
Eb1mom
I have been working on this for a while and even with help
from here seem to be getting nowhere.Two tables, one has
production information, the other delay...
|
July 24th, 2004 10:18 AM
by eb1mom
|
2 |
93 |
|
|
Labels not associated with controls by
Alcide
Hello all,
I go to Report Wizard, select a table from the drop-down, group on one field, choose Align Left 2 and it generates a report with some of the labels...
|
|
1 |
141 |
|
|
|
|
3 |
159 |
|
|
repeating group headers by
D Minter
My report has two groups plus the detail. Because I want
a new page for each change in group 1 values, I placed a
page break below that group's footer. I...
|
July 24th, 2004 12:28 AM
by Alcide
|
5 |
117 |
|
|
|
|
3 |
114 |
|
|
Recalculating field when report opens by
Gavin
Hello.
I am trying to recalculate the age for a report. The table consists of the member's name, date of birth and age (which is automatically entered based...
|
July 23rd, 2004 11:21 PM
by fredg
|
3 |
301 |
|
|
report grouping (Access 97) by
Joseph Barrett
I need to know how to repeat information in fields that
are grouped. If I need to delete a group, how do I do that?
For instance, if town name is grouped, I...
|
|
1 |
98 |
|
|
Lebans Print Lines Issue by
I have used Lebans Print Lines succesfully on one report
thus far, but when I tried to use the same method on a
second report for some reason it cuts the first...
|
|
1 |
654 |
|
|
Reporting Birthdays by
turbogreg17
I have a "date of birth (DOB)" field in a table. How to I get a report (or query?) to only show/return folks with birthdays within the next 30...
( 1 2)
|
|
11 |
214 |
|
|
Borders/Gridlines on Reports by
Winston
We are working on an Access report that will, in the end,
look like a spreadsheet, with many rows and columns of
data. It is much easier to review the data if...
|
|
2 |
127 |
|
|
Help!! on converting Access Graphs/Charts by
Zohra
Hi there=)
Basically im working on a database system designed to
capture data via the form. Its got many tables related as
well as Queries, Reports and...
|
|
1 |
126 |
|
|
Report with no record source by
BilboBaggins
Hi all
I am trying to get a report to work running with no record
source. Most fields on the report are Dlookup or Dcount
fields so no source needed. I am...
|
July 23rd, 2004 07:46 PM
by fredg
|
1 |
86 |
|
|
Filtering a Subreport by
Can
I create a filter string that filters a report perfectly.
I want that same filter string to filter an unbound
subreport. The subreport is unbound because of...
|
|
7 |
119 |
|
|
MonthName by
mate
I use the following expression in a report, =MonthName
(DatePart("m",)). This expression returns the
desired results in Access 2002 however produces...
|
|
1 |
72 |
|
|
Report Design by
Thanes
I am designing a final report for all of the information I have in my database. Is it possible to have (before the report is generated) a form that users...
|
|
1 |
67 |
|
|
Group header to show "Group Cont'd" by
Eric Blitzer
I have a report that has a group header. If the group has
so may records that it takes up two pages I would like the
page header(on the following page) to...
|
|
2 |
350 |
|
|
|
July 23rd, 2004 03:27 PM
by SA
|
2 |
214 |
|
|
SUM (?) in Report by
an
Hello!
In Report I have:
Textbox1 to display VolPurge1 (numeric data field);
Textbox2 to display VolPurge2 ( " " " );
and so on, to
Textbox9 to...
|
July 23rd, 2004 03:09 PM
by an
|
9 |
171 |