Hello Evrebody,
I am trying to distribute a somewhat coplexe report
with subreports. It has to be delivered to many people
in Europe and North America. I have no idea what

I am using the following:
=([ShippingName]+Chr(13)+Chr(10)) & ([CompanyName]+Chr(13)+Chr(10)) &
([ShippingAddress1]+Chr(13)+Chr(10)) &
([ShippingAddress2]+Chr(13)+Chr(10)) & [ShippingCity] & "," & " " &

I have a series of reports that are all essentially the same except for
an extra grouping.  I figured that, if I set the Section to Not Visible
(Visible = False) then the grouping would also disappear.  Except that
I was wrong.

I have set the "can shrink" option to yes for a group of address fields,
and also grouped these fields. But the shrinking does not appear.
Are there any more options to set?

Can I use a formula or method in the Report Header?  If so, can I use a Year
function of some sort, but add the following year, ie: 2006?  Would it look
something like this: =Year(Now())

I have a deliveries database that i created. All items delivered go into the
subform at the bottom. When i print my report it prints the last item in the
subform as the firs. This doesn't work because the first item is usually a
heading and so now things don't look right. what ...

In a MS Access report, I need to create Subtotals based on a particular
Group/Sort.
My report has 3 different Group/Sorts with the following relationships:
Group/Sort <--> Relationship

My report prints a receipt with all the customers details in the page header.
The products purchased are in the details section of the report. The fields
used for each product are 'product number', 'description' and 'price'.
In the page footer I would like to display the sum of ...

I have a pop up that when closes leaves the main form not maximized. Why the
main form does not stay maximised I do not know. This sometimed happens when
the report which gets parameters from the  pop upform is minimized. This
effects the state of the main form (Why???) I have ...

I work with a database that allows users to enter multiple discrepancies into
a table under one unique report number.  The table and queary both show the
report number once for each entered discrepancy.  I have a report that shows
the discrepancy information in a sub-report, but ...

I am using a database to track changes in 2 tables via a report.  The report
shows the original table and the edited table side by side, but I would like
to highlight the fields if they have changed. (i.e., if Textbox1 <>Textbox 2,
highlight)  I tried using Conditional formatting ...

i have a report with 3 phone number fields
phone1
phone2
phone3

I have a report named rptLoansErrorRateReport. Textbox "ErrorCount" in
Detail section of this report has Control Source:
=DCount("ValidError","ErrorTable","NameID=" &
[Reports]![rptLoansErrorRateReport]![cboNameID] & " AND

In MS Access, On a Report:
I want a total on a group of records. Whats more, I want to subtotal this
group of records, but add the text box to another group's footer.
How can I do this?????

I have a report that collects all open work orders.  I would like a total
amount of work orders collected in the footer.  How do I write this to have
it automatically calculated?
I have something like =Count(*)