I probably haven't understood how the aggregate functions are supposed to
work, but I have the following problem:
I have a report on student marks, based on a query, grouped by the students
Class name.

Help please.............
How to add extra column in cross tab query. Actually
problem is i have to design a report based on crosstab
query. The query sometimes gives 2columns sometimes 3...

I have a WorkOrder form with several dozen fields.  Some of the fields are
indexes into lookup tables.  When I use the Report Wizard to create a report
with just a few of the fields, everything is fine, but when I try and create
a report with all the fields, it generates a type ...

Hi every body
I want to make report for Leave Planner which will show Employee Names in
one column; vertically and months names horizontally  like Jan, Feb and so
on.

My report is sorting by the numeric autokey value, not the text value of a
particular lookup field, and I want to fix it to sort alphabetically by the
text value.  I am using the "sorting and grouping" and it is using only the
numeric value.

I'm really stumped on this one.  I have a report that is grouped by student.  
Each student has a number of scores in the detail section labeled test1,
test2, test3 etc.  There about 40 of these tests.  each student will have
anywhere from 20 to thirty of these records that ...

I have imported a lengthy Excel Spreadsheet into Access (also tried linking).
The spreadsheet contains 3 columns: Description, CODE, and PRICE.  I put
criteria in the query for CODE to pull out only those code numbers I need for
the report.   I need to also, for those code ...

I have converted an Access 97 database to 2003 and I get the error message:  
"AciveX component can't Create Object" when using the label creation wizzard.
What is the fix for this?
Thanks for your help in advance.

Good Day.
Anyone have a quick trick to change the backColor of a
text field for every other line in a report.  
I want one line to be white, the next line of the report

tblWorkOrders has two fields TakenBy and AssignedTo which are both employees
and are relations to tblEmployees.  My forms are working fine, but I'm not
sure how to build a report.  The Report Wizard only let's me specify Name of
tblEmployees once, and I'm not clear on how to ...

I am trying to number an Access report starting from page 41 sequentially
through the end (about 265 pages).  I can get some expressions (using the
Format([Page]) command) to start at 41 but when the report reaches 50 it
becomes 410 instead and proceeds sequentially from that ...

I have an split database application that, amongst
other facilities, gives the user the option of printing
mailing labels. The application runs in an Access 2K
environment.

I have a field on the report that includes City, State,
Country.  It is written so that if there is no State, it
will skip the state and just report City and Country.
(and omit comma after state)

I would like to open a report and restrict its records to those
Specified by the value in a text box on the form.  The report is based on
A query.  The criteria in the query is blank.  I don’t what to be prompted by
The where condition in my code.   Does anyone know how to do that?

A field on my report has a control source which is a memo field. As
such, I have set the "Can Grow" property of this field to Yes.
If I leave it as that, the data in the field wraps as expected.
However, if I try and apply conditional formatting, the field will