I have a field in my database that is used to track 3 program types that are
1 character in length.  The report is designed to sort by program types and
give a total for each for each employee.  Is there a way to convert this one
character to the actual program type on the ...

Simple question - but driving me crazy.
I just want a sum on a report which is this:
=Sum([ClosePeriod])
But it returns a line for every record. I just want one line showing this sum.

I have a crosstab report that has the days of the month across the top
as "column headings" and workcenters as rows with accomplished hours
as the data.  I would like to highlight todays column each day.  Here
is what my report looks like:

I using the fConcatChild code to consolidate informaiton from 1 table to
another.
this function is taking all the information available form the many table
and replicating in for each record count.

Good morning all
I'm struggling with creating simple dynamic links in a report. All I want to
do is pull that path and the text to display from a field in my database.
Here's the steps I'm taking that are not working.

OK - I've tried looking everywhere on the web and maybe am overlooking
something very simple
How can I sum up the number of "passes" for 6 fields that have either a
"pass", "fail" or is blank.

I want to base a report on a parameter query. The query asks for a date. I
tried to build a report from it, but it requests a parameter for every single
field.
Suggestions?

I have a report that includes a cell phone field as a separate line in the
report. It leaves a blank line when the cellphone field is empty. Is there a
way to skip this and avoid a blank line?
OMEd

I have 2 tables, (1) group table and (2) member table. There is a one to
many relationship: each group has several members in member tables but no
member belongs to more than one group. The linking relationship is a group
ID.

I want to generate a report that contains several field from 5 different
tables and I want the result to be displayed by each department (department
is a filed in one of my tables). I have tried using Group By in my query but
I think it can only be used with aggregate functions.

I'm stumped and need some help. I have a query which pulls data for various
sustainability metrics for each month of 2007 and 2008. How do I get the 2007
on one set of bars and 2008 on another set of bars? Thank you so much! Jani

When I produce my very basic report, I have a sub report that displays
additional information on the main report records. When I view the report it
all looks fine, when I print it, I only get the main report details, none of
the subreport at all. Strange but  true!

I am using Access 2K on a win 2 k pro machine.
I have created a custom report which is 7 in long by 7.5 inches wide
Margins are .25 all around.
When I pull up my report in design mode it wont allow me to go past 6.00 in

I have a table called "data" with fields TIME and LEVEL.
I generate a report "levels" of LEVEL against TIME grouped by day and week.
The query I use is like this...
SELECT data.TIME, data.LEVEL

    I have a short report I'd like to configure to print 2 to a page. I'll cut
the paper in half horizontally after they are printed.
The report is grouped on a field and the detail section can have anywhere
from 1 to 6 or 7 lines (so the detail section is not static in height).