I'm trying to make a report where records from some query i made are shown.
at the end of the report i want to show the totals of the data shown in the
report.
In these totals I want to count the amount of different appearances of a

I need to take the data from several queries, and have them all show their
data on one report.
I built a query retrieving data from three other queries, but then if query1
has two records resulting, then my report query duplicates the data from the

  In a report we have a bool column which is bound to a textbox. The value
in textbox depends upon whether [ColumnBool] is True or False.
Following the condition kept in Control Source :
   =IIf([ColumnBool]=True,"a","")

I'm creating a Profit and Loss account report- I've got a range of general
ledger codes- with a relevamt hirearch in a table-
Problem is can't get the report to calculate on specific GL codes- for
example- to calculate Gross Profit need to Calc Sales less cost of sales- i.e

I have a QBF with 10 fields which the user can  select
any combination of fields to create a query. I need to
create a Report based on that ever changing query. I am
not sure how to attack this one. Suggestions gratefully

When I print a report using a command button, once the report is sent to the
printer Access crashes with a fatal error.  
The report query runs fine and it will even Preview Report fine.  It only
has to do with the printing.  Let me know if this does not explain the

I have a report pulling data from a table that has the date column defined as
text.  Is there a way to convert this field to a date format on the report?  
As it is now, all sorting is incorrect because it views the field as text.  
Thanks in advance.

I'm trying to get Access Reports to provide a sum at the bottom of each of
several columns.

Is it possible to have my data printout in a calendar type format? My
example would be each salesman sells X amount of items per day. Is there a
way for it to show up in a calendar format?
ex.

"For report sections, you can't use a macro or Visual Basic to set the Height
property when you print or preview a report."
That's straight from the help files for MS Access.  I read this and
understand.  Nevertheless, I have to find some way of adding extra blank

I have a report that prints a page header only on pages after the first. I
accomplish this in the PageHeaderSection_Format event with the following
code:
Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As

From a command button on a form I have the following code to open a report:
DoCmd.OpenReport "rptRouteMilesByTen", acViewPreview
In the reports On Open code I want the report to zoom to 100% but I get an
error:

I have found a previous posting, but it relates to
subreports totals...I tried to apply it to my report, but
it does not work...
The following is my problem:

This has got to be much easier than I'm making it, but for the life of me I
just can't see it.
I need to create a report that summarizes data by month across years; I have
data for 2000-2004 and can run crosstab queries to summarize by month and

Hi friends,
            I have a column in access report in which a particular
column(say "columnBool")is attach to datasource whose datatype is BIT.
Hence a checkbox appears in column "columnBool".