I'm looking for some help with a sub-report problem in Access97.  Here are
the basic things that may be relevant...
The sub-report has labels for it's columns in a group header (because report
headers won't print in sub-reports).

Looking for a way to eliminate duplicate records by line in a report.  I have
found the 'hide duplicates' in the properties for a particular field, but I
would like to eliminate the entire line in a report based on the duplicate
record in one of the fields-and not leave a blank ...

When I try to sort a field of address numbers in a report, the numbers are
sorted like you are soring in windows,
1,12,14,15,16,20,20,21.3,30,32,32,4,4,40,41...
any idea to get them to sort normaly in numeric order.

I need to print invoices on pre-printed forms, with totals to print in the
boxes in bottom-right corner of printed forms.  I requested how to print a
group footer at a set location and received reference to view article 208979
in Knowledge Base.  The first method in this article ...

I have a form and sub form where i add additional records
within the sub form for each item in the main form.
I wish to ensure that only a maximum of 14 records are
permitted to be added in the subform and once the 14 are

Need help on printing totals for invoices on preprinted forms, i.e., tax,
freight, totals must print in respective boxes on pre-printed forms.  My
controls are calculating correctly, but I just can't get them to print low
enough on page to hit the boxes.

If I set up a report with for example 3 columns, based on a table of names,
addresses etc, then close it down or add a name to the table, I find that on
reopening - the report will default to single column, it will lose any
amendments in Page Setup such as margin changes etc. ...

I developed an Access XP application with report preview.
I installed Access XP SP3 runtime to my customer pc.
With full Access report previews have then popup menu (menu
with options like Print, Set Page, Save as, Export...)

I want to choose a subset of records in a query to audit.  For example, in a
query with 200 records, I want to randomly select every 20 records to output
to a report.  It does not need to be completely random - selecting every 10th
record would also work.

How do I add up numbers in a column in Microsoft Access Report?

i know how to print address labels in access..  i would like to know if it is
possible to print a double of all these addresses at the same time.

How do I ensure that, in a report, if a field is empty for some records, the
ones below close up, please? It seems to occur automatically if you use the
label wizard but not if you construct the report in design view.
Something to do with "can shrink" perhaps? But if so which ...

Access 2003: I type lowercase states and then format them uppercase by using

Label Wizard, the states are lowercase.  I think this is new to 2003.  Any
ideas?

I have created a series of reports.  At the very end of each report after
the last record, I wish to have an area of text where I can explain the
report and offer suggestions/examples on how to understand the data.  Being
very long-winded, I can't fit all my explanation text into ...

Hi!  I have created a query that pulls records from tables and queries.  The
query has duplicates that print on the report.  The query is based on 4 other
queries with the common factor being in a table, employee ID.  I need the
records to sort by employee ID and only display ...