Hello,
We have a SQL database setup using an Access frontend with various menus
setup.  One of the menus is a Report menu that allows users to run reports
setup in the Access frontend so the reports are contained in the Report

I have 2 related tables. One is for Groups with fields like name, address,
town, etc. The second table has records for individuals in each group (3-5
members in each group). The tables are related by IDs for the Groups and
individual IDs for the members.

I am getting this "type mismatch" error when I try to open a report
that has no records.  The report normally displays a picture of the
client if they have one or more records in the report. If they don't,
it should be able to still open the report but just show no records. I

I downloaded How to skip used mailing labels and print duplicates in Access
2002. It seems to be working fine until I try to print. It then prints from
the first label and not as the preview showed. This is driving me buggy. What
am I missing?

I have a report based on several crosstab qry and that report gives me the
data i want from every sales office. Now i want a total. Just a page with all
totals. Do i have to rebuild all my crosstab qry, or it's simply change
something on my report? I've tried to delete my group ...

I'm having trouble getting my report grouping correct. I'm trying to
print invoices (report grouped by OrderNumber), but sorted in order by
the number of items and location.
I created a query that totaled the number of items and location, and

I'd like some guidance on how best to create an appointment report.  The goal
is to have a summary page having one line per appointment and then a one page
report for each appointment.
What is the best way to do this (report/subreport, macro calling two

I am working on a  report which summarizes orders from different customers
over  a certain time frame.
I have a text box which totals the orders for each customer in the footer
for the customer.  I would like to show the customer header and the detailed

I am having trouble getting my head around the tables I would need to produce
the following document.
I have two hundred agencies that each get a letter.  
There are nine categories of one-time only funds that they might be eligible

I'm building a report based on several crosstab qry and it seem ok with
values. That report has group values.
I want, at some point, a line with totals as well as a line with the
difference between 2 lines, like expenses to sales. Quite simple, i guess.

I have created a 2 column to create a booklet. My report uses landscape and
a page size of 5-1/2 wide and 8-1/2 tall. Each page is printed on the left
side in landscape. Is there any way to get every other page printed on the
right side of each page?

I have created a crosstab query with the last name of employees meeting
certain criteria as column headings.  Naturally, the employees meeting the
criteria can change so the column headings change; but report designs require
constant field names.  How do I design a report for ...

Unusual question possibly.  I've created a database for the company I work
for which has an input form when the file is opened.  There are buttons on
the form which allow the user to press them to see a list of records which
meet the requirements.  (One button says 'Windows' and ...

I have a report that currently shows all open jobs broken down by
helicopter and stage of work being accomplished.  I have a table that
is updated to show the progress of the helicopter thru its stages and
the helicopter is the primary key.  What I would like to be able to do

Does anybody know if there is a way to set an absolute position for a text
box in a report?
I have controls above it that need to be set to 'Can Shrink'.  Trouble is
when the controls shrink it moves the text box up.