This seems so simple but I can't solve it.  I have a report that groups a
schedule by part number (and sorts them in ascending order) and shows
detailed lines of factory schedules and customer orders.  I would like a
total by part number to verify that sales and factory schedules ...

I have a report using a query as the data source. The query presents the
clients in numerical order, but the reports are not in numerical order. I
need this for the mailing aspect.  Thanks

I have a field called contractnum which contains a variable-length
string from 8 -17
characters.  My difficulty is that when I sort them, I would like to
group them based on on the section of digits just before the last.

I have a report based on a query that shows customer number, year, total
sales, grouped by customer number.  In the footer of the customer number
I have a graph created using the graph wizard.
It usually works BUT sometimes it shows data from a prior or future

I created a report in Access 2000, that I have used for years with no
problem.  Recently I was given a new computer and it has WindowsXP and
Microsoft Office 2003 professional on it.  It uses MS Access 2003.  I
converted all of my reports to this new version but I am having some ...

(MS Access 2002)
I'm having trouble with report filters.
When applying the filter, the report dosen't show the correct data, this can
vary from the correctly filtered data, no data and partial data using the

Can i in a Report make one of my text field Upside/down ?
It is a card there shall stan up, and there fore the one Text field
shall bee Upside/down I can in excel by format and rotate my text
but how in Access

How do I send a report (via a button) directly to a printer bypassing the
print preview screen?
I still want the general office printer selection dialog box to open up, so
the users can select their local printer.

We use Access's built-in function for exporting reports to Excel quite a bit
and have been very happy with it. However, there are a couple reports that
we'd like to export to Excel and have more control over the formatting of
the produced spreadsheet.

I need to group employee hours by workweek (Sunday - Saturday) within
individual timesheets for a pay period based on dates.
So, the most recent pay period was 10/25 - 11/09, which starts on a Thrusday
and ends on a Thursday.

Is it possible to print a single record from a Report in Access 2007?
Is it possible to print selected records (ex. Record 1,3, 7) from a Report
in Access 2007?

In Access 2007 how is it possible to print one single record or choose a
couple of records from an Access 2007 Report?
i know how to print one single record from an Access 2007 Form, but not
Report.

I created a chart but I need to show my total on the pie not just my legend.
For example:
In this pie shows the model number of the equipment, but it doesn't show me
how many of them I purchased and that's what I need to show in addition to

I am having trouble getting a Grand Total in the footer of my report to
calculate correctly.
I tried a Dsum expression but it was verrrryyyy sloooowww! It looked like
this (one for each Group):

How can i make it so i only get one record on a page?
regrads
alvin