Some groups on my report are small enough so I would like them to snage on one
page, on the other hands some are large enough to occupy a single page.
How can I control the display?
Clara

I have a database where my information is seperated by month.  How do I print
out "selected records"?  Meaning, I want to print out one month at a time and
have each month on a seperate sheet.
Thanks

I am using MS ACCESS XP. I setup an crosstab query and want to create a
crosstab report but following the Help file instruction and just realized,
the report columns are fixed and not dynamic.  Is there any solution that
will generate the crosstab dynamic column?

I've searched through the message boards and I can't seem to an answer to my
particular question, so here goes:
I have a company logo at the top of all my reports. Rather than embed the
image I linked it to an image stored in the subfolder of the back end of the

I have a table in access base on dates example, 3/1/2007 , 3/10/2007 ,
4/20/2007 and others.
How do I create a monthly or yearly calendar showing theses dates in access
report?

I have a report that has many pages.  How can I print
the first page using vba?
I have been looking around and all looks complicated.
Is there a simple way to do it?

I created a report and a subreport.  The issue is that my subtotal
which totals the main detail section in the report footer carries over
to the next page if subreport does not fit on the first page.  Is
there a way to set it so that the subtotal stays on the same page as

There is a extra height blank gap between the first and the second group,
but to other groups , the heights of gaps are normal. The following my
setting:
Force New Page : none

I am trying to create a report that has 5 columns (M Tu W Tu F) with
corresponding data underneath.  I'd like each day to appear in a different
column.  The closest I came to getting it right was by using New Row or
Column: Before Section on my GroupHeader.  Everything looks good ...

can I do =Count([Q6=1]) ?
How do I write a statement to count all answers to Q6 where option=1 in a
report?
Please help!

I have a form with multiple search boxes to filter on one or more different
fields on the form. When any of the search boxes are changed, I make up an
SQL statement and poke it at the record source of a subform on the main form
to produce the filtered results that I

I need to show a date in the Report Header part of my report.  Currently the
criteria to print the report asks you to choose a specific day.  I want the
date to show on the report up by the title to avoid looking through the whole
report to figure out what the date is.  Is there ...

When I try to ODBC an access database, I can't ODBC and keep the format of a
custom number.  So, instead of 4.00 its reading 400.  I formatted the column
to read @@@@@@@.@@ as the number format.  Is there a way I can preserve the
number formatting when I use ODBC to query the ...

Dear anyone,
Can the Access do the shift from printing the first column to the next
column as we needed, in place of its printing to the bottom and continuing
its printing itself?  

You guys rule...!
I am getting it done here better than anywhere I have tried.
Next problem:
I have a form open with all the information filled in to a record to be