My setup: One form ("Soccer or Baseball") and one report.  I have two fields
"Designated Area" and "Product Type" that I am working with.  "Designated
Area" is the group, and "Product Type" is the restrictor.  
There are two options in product type: "Soccer" and "baseball"

Hi there, I'm quite new to Access, so please be gentle!
I've created a Report to set the format in which I want my records
printed, however at the moment, when I click the Print Record button
that I created with a Wizard, if prints every single record in the

how do i keep from defaulting to the primary key within a nested sort.
Thank you very much.
Lance

Hello: I am printing a tabular report on a list of names. The tabular report
has five fields. The five columns are too wide to print on one page. In
design view I did click and drag to reduce the width of the columns, It's too
tedious and takes too much time and still takes up ...

Hi,  I have a report I created in design view.  If I have the "design view
window" smaller than the Access database window/work space, I am unable to
resize the window.  I do this when I have 2 reports open in design view at
the same time and I comparing property settings from ...

I am running a report that is generated from a table field called "SrvID".  
There are several individual reports that can be generated by the same query
with SrvID as the driving condition.  Several of the reports run perfectly
but two or three of them, using the same query, ...

Something is just skipping my mind.  All I want to do is set up a report that
details out data by year, then give totals by year.  Not one line grand
total.  See below data and report structure.  I know this is probably simple,
but I just can't seem to grasp it.  Thanks in ...

I have the following code, but "0" is not showing up (it's blank).  Any ideas
why?  (By the way, "Allocated Case Volume" is a number.")
=Sum(IIf([Product Type]=Forms![Allied or Monster]!ProductTypeV And
[Transition Complete YN]=True,[Allocated Case Volume],Null))

I have stumbled upon an issue and hopefully somebody has an idea.
I have reports in my application and they seem to be fine on some
computers running
XP SP2 / Access 2003. On one of the computers, with the same

I have 4 different self-contained reports I would like to variously combine
into one continuous "print job" based on various parameters chosen by the
user off a master print control form.
Currently, the record source for each report is set using the openarg:

Using parameters with queries and reports
I'm using a form to supply data to a parameter query.  When I run the
report, it opens the form, I enter the data to pass to the query, click "ok"
it hides the form, runs the query and displays the resut in a datasheet query

I have been reading your responses and think you may be able to help me.  I
had a query & form based on a table and a report from the query.  The table
had Lookup fields.  I changed the lookup fields to text and modified my form
to include lookup fields.  The table, query and ...

I have a report that lists all current prospects with relevant details.
Current prospects each have a Corp Office Rep (COR) that looks after them and
the report, via the use of group headers and footers lists all current
prospects per COR.

Access 2003:
Print window needs to open with the report in the center of a maximized
window and with a preset zoom setting.
Thanks

Some help please from someone who is still learning!!
I have a report based on a query and I would like to add up the totals for
each column, ideally within each group.
My report at the moment is grouped by Region (This is sales data for a sales