I have a report with a sub report in it to list languages.  The languages
different people speak will come out on individual lines for each person on
the subreport as follows
Spanish

Because Chart Type literal constants don't work in Access. I haven't
figured out why.
I have been using the numbers associated with the constants.
I have a problem now where the following string works on forms (Example

Hi Folks - I have a total in a group header. The field was originally in the
detail section, but I moved it so I would see only one total per grouping,
instead of seeing the total on every detail record. Now, I need a grand
total based on the group heading figure. When I use ...

I use access 2003 and want to send 5 or 6 reports by email at the same time
i.e not sending them individually.
Can anyone please help

I've a field under Details which displays the results when '=Age > 18' but
the report is also showing lines of records when the same field contains Age
=< 18.
HOWTO hide unneeded lines in a report based on the results/content of a

My question is: can I set a field in a report of a size, that automaticly
fits to the content. For example, the user writes a text of 1 row, the field
will automaticly take only one row on the printed sheet. The same with 2, 3
or 4 rows etc.

I need you help. I am trying create very simple hardcopy survey print
database. But i got stuck on the area where i need to print number of
copies of the report based upon the value on the field.
Basically, I am trying to print the survey sheets for the number of

I know that this has been asked and answered before, but can't tind the
topic.... Openig a report it's size is Fit. What to do so they would open at
100% allways?
thanks, if anyone...

I thought I resolved this issue but it came back to haunt me.
My question is:
How do I get my group footer to print without the group header?
The way my report works:

 I've been searching the forums looking at answers to this but none
of them seem to work for me. I have a table (tbl_countries) with 3
fields(flag_id,flag_name,flag_image). As you may be able to guess this
tables contains flags, field one is an autonumber, field2 a countries

I have a report design to print data on cheque. I have two options: print
all and print for selected item. I have created the two source queries but
wondwer if I can change to Record Source of the report when executing the
docmd.openreport "rptCheque"

Hi
I have command button with the following code on:
Private Sub cmdPrintDespatchNote_Click()
   Dim lngOrderNum As Long

How can I make the subreport show the same list as  the main report as i move
to the next main report pages.  The problem is that whenever, I move to the
new pages, the subreport still show the very same list on  the main report.
Thanks for the attention.

I have a report that has a default Sort and Grouping (field names and
Asc/Dsc).
I also want to be able to set the Sort Order on the fly from within a form
via a command button.using OrderBy and OrderByOn.

Is it possible to display the detail of a report in a single row, instead of
down the page across multiple rows?
I'm looking to generate something like this:
                                                   2006