Hi All: Trying to have a footer field that will only total top 2 values of
grouped data above. For example : I have a reprt that shows 2 people
grouped, and each person can have multiple scores: 21, 22, 25 etc. I want
its footer to add just the 22 & 25 for that person and the ...

I have a Text box named ACTIVITY. I the activity could be one of four codes.
B,C,I,X. I would like to count only the "X" and put it on the report header.
How can i do this?
Thanks for your help.

I everybody,
I would like to know if anyone can explaine me why in a report preview the
correct control values are shown but when printed those  controls are showned
as #Name?.

I'm having a problem to select Year Range like  from 2003 to 2004.  I try to
open the charts and it gives me the report in 2003 only because it show as:
TRANSFORM Count(qryname.Field1) AS [The Value]
SELECT qryname.[Field2], qryname.Field2, Count(qryname.Field1) AS [Total Of

When I try to run a report based on some queries, with a grand total in the
report footer, I get an error message saying something like the title of this
post (sorry my office is in french).  However, there are no group by clause
in my queries, just the one in the report.  ...

I would like to export some MS-Access reports output to pdf.
However, the only possibility offered by Access (afaik) for me to export
formatted output is snp (snapshot) (I use MS-Office XP Prof. 2002 version).
With formatted output I mean the *exactly* output I produce from ...

Is there a way to prevent a group footer from being the
first thing printed at the top of a page? I'm only using
the group footer to create space between sections. Do I
have to make some evaluation to determine whether to

How do I print the correct information under the right column heading if I
only need information for 3days.  I have a crosstab query set up with a date
control where I enter a start and end date.  This report is set up to run
weekly (5days).  My column headings are fixed where my ...

I have run a query from my table and have a number of
text fields without any text filled in or are blank.
What is the "criteria" expression that I can use to not
print a field if the text field is blank, so that it will

Hi list, I have a report that I am generating using the Label Wizard.  The
field I need to put into it is an address field that contains:
Address, City, State, ZIP
This is a single field, whos elements are seperated by chr(10).  Is there a

i cant seem to print zip codes properly on access when i try to print them on
labels.
for example 92105-4545 prints out 921054545 with no dash i storing the data
with an input mask of 00000\-9999;0;* and that didnt work so i deleted it and

I have created an OLE Object in an Access report containing two Excel
Worksheets (Class = Excel.Chart.8).
The first Worksheet named [Chart] contains...well, a chart.  The
second Worksheet is named [ChartData].  The chart references the data

I need to show in a report when an employee will be eligible for a certain
benefit.  The eligibility is basically the first day of the first calendar
quarter AFTER one complete year of employment.  For example, if a person's
hire date is 9/5/2003, he becomes eligible on 10/1/2004 ...

we would like help in outlining our plans to participate in an upcoming
national event by showing why it is important as we are an indigenous group.

I have memo fields to print that vary in the number of lines required. Using
fixed height text boxes results in large gaps of white space, but I get
errors when I try to size a text box at run time. Is there such a thing as
automatic sizing of a text box to accomodate memo fields, ...