I have a Totals query based on a query with the fields [ClubName],
[Zone] and [Group] in the same table.
Clubs are in several groups and any one of four zones.
This produces a concatenated list of clubs in each zone:

My question is, can I  have a set of 12 unbound textboxes and set their
controlsource to the appropriate month, this way I don't need to open the
report every month to add a new month field.
Here is what I have currently...

I have MS Office 2003.  I cannot create/review Reports in Access.  I receive
the message, The Report Function has been canceled.  How do I restore or
uncancel the Report Function  Thank you

hey all,
i have come across this yet and was hoping for a "Heads Up". I have a
Customers Invoice report and was wondering what happens when the line items
exceed the first page. Is there anything that i need to do to handle this or

Put on your thinking caps...Here's what I'm trying to do. I want to create a
report from a order entry table I created. I want to set up a form with check
boxes for each field in the table. (Not sure if the check boxes is the right
way to go) Then I want the user to put a check ...

I am having a problem of my reports looking different depending on which user
accesses the report.  Meaning, if I run the report from my PC I will get back
say 800 items on 34 pages, if another person in the department runs the same
report gets back the same 800 items but it is ...

I have a report in an Access 2002 database in which one field for one record
displays blank. The Control Source for the field on the report is an
expression containing a concatenation of several of the fields from a table.
There is data in the fields for this record in the table. ...

I need to update dynamically the subreport record source (query),
which contains "account number" field  in WHERE part of the query,
by the value of "account number" text box from main report.
I need this to update subreport content for each page of the main report.

I'm attempting to create a report that is pulling data from forms and
subforms. The problem is that the subforms sometimes have more than one
record. So when I run the report, the main record shows up more than once,
because the data in the subforms is different. Example. The ...

This is an old one and I know it is caused by something, often just the tip
of a dividing line, sticking out beyond the printable area of the paper.
My question is this.
Is there any way to see where the edge of the page is going to be?

Hi all -- very much a newbie, so please bear with me on this.
I created a report in Access using a table which contains a field with links
to images on the web.  
As suggested by others, I've created a picturebox and updated the code in

On a particular report, I have a column that includes text boxes formatted as
Currency above/below text boxes formatted as Standard, from 0 to 3 decimal
points.
Although all the text boxes are identical in all other regards

I've been trying to use the DCount function to count the number of records in
a report group where the specified field is >990, with the following control
source placed into the group footer:
=DCount("[School]","Sheet1","[Papers] >99")

I'm not sure if this can be done but I would like to run a report that shows
all of the employees that a '90 day eval' coming up in the next month. I have
the date of the eval entered into my data base and i am hoping their is a way
to just show those people with an eval date in ...

I'm trying to duplicate behavior for a Report text box, as far as number of
chars per line, etc - to that of form text box where user enters Order data.
I've set the dimensions, format, Font, even cut and paste so borders exact.
Yet, cannot seem to exactly duplicate