Is it possible to repeat a detail section twice for each grouping...like in a
cheque stub where the payment detail section is generated twice on the body
of a page while the cheque itself is printed once.
I have built a query that shows the details and the report groups it

I have a situation where I am entering data for a purchase order via a Form.
On the form I have a command button that will allow me to print a Report that
contains the data that was entered via the Form. I need to be able to print
two reports - one copy for Accounting and a ...

Dear Access experts in this forum:
I'm new to Access writer and are trying to create a financial
statement. I'm trying to figure out a way to custom define the
groupings. Your help is highly appreciated!

I want to put a text box in a report which should display the count of
records from a different query (which is in the same database). Is there a
way to achieve it without linking the table?. I put a select statement in the
control source property. It doesn't give any error but ...

Windows XP
Access 2000
I have connected 2 PC’s using a cross over cable to form a small network. I
have set 1 printer as a shared printer on the “Master” PC and the setup seems

I want to generate reports that will be mailed to customers from an Access
application and would like to have the report converted to PDF.  Is there a
plug-in that will allow that to occur on machines that may not have Adobe
Acrobat, in the same way that there is a run-time ...

I am making a report that I am using as a letter.  (I know, Word is used for
letters, but my data is a little more complicated than that and I can't
figure out how to merge it.)  In this letter, there is about 3 paragraphs
that has no data so I am making a big label for this ...

I want to get a median for a set of data in a report.  I tried to make two
queries with top 50% of the data in both acending and descending order; then
take the average of the max value from the acending order query and the min
value from the descending order query.  The logic ...

Earlier this week I had a problem getting a page header to NOT print on the
first page of a group.  Marshall's response was to add the following code:
Private Sub GroupFooter1_Format(Cancel As Integer, FormatCount As Integer)
   Me.Section(3).Visible = False

The right-hand side of my report dispalys a list of amounts, with subtotals
and totals.  In many cases, I have added lines, either above or below the
related control.
Usually (not always), when I view the report on the screen, I can see all of

I have an Access Report where I would like only the last 4-digits of the SSN
to show when printing.  I have already used the function:
=right([myssn],4)
=right([spousessn],4)

Earlier this week I had a problem getting a page header to NOT print on the
first page of a group.  Marshall's response was to add the following code:
Private Sub GroupFooter1_Format(Cancel As Integer, FormatCount As Integer)
   Me.Section(3).Visible = False

Earlier this week I had a problem getting a page header to NOT print on the
first page of a group.  Marshall's response was to add the following code:
Private Sub GroupFooter1_Format(Cancel As Integer, FormatCount As Integer)
   Me.Section(3).Visible = False

I have tried codes from the following links:
http://www.mvps.org/access/queries/qry0019.htm
http://support.microsoft.com/default.aspx?scid=kb;en-us;210581&Product=acc#XSLTH
3133121123120121120120
However, these codes return the same value for ALL my questions in a

I have created a report that contains 17 subreports (one for each
distribution center being tracked).  
Each subreport is based on a query specific to each of the distribution
centers.  When I run the individual subreports, they look correct and return