I built a database in 2007, then saved as 2003  so it can be used by others
in the office.  reports work fine in 2007, says docmd was cancelled when used
in 2003.
while in 2003, I am unable to build a new report in design or with the wizard.

I have a report that is based upon a query that filters the data in a variety
of ways. The net result is a listing of Zip Codes that I ultimately use as a
part of the data for a report. The contents of this report is limited to the
Zip Codes from the query. (Not a true filter) I ...

I have a PivotChart created in a Query.  I would like to display this
PivotChart (since it is a stacked bar graph), in a report.  Can this be done
in Access 2003?
Thanks for any help.

I have a report that includes several groups.  The footers all include fields
that are the sum of calculated fields within the detail.  When adding totals
to a footer using the grouping, the total becomes part of the "layout" group
for that field.  However, the grouping totals ...

I would like to have a table (or at least the blocks of a table) in my
report.  I want the table to be the same number of rows no matter how many
values my query places into the report (anywhere from 1 to 16).
I need the table to always be the same length to match a specified ...

I am creating a purchase order in msaccess.  In sub-form I have fields as
below :
serial no, description, qty, unit price, total.
Once I print I want to get all lines as per line number series per invoice.

I am a novice access user who is looking at someone else's application.  
They have a Post Table and a Comments table.  There is an id field in the
Post table that links to a Post_Id field in the comments table.  When I open
the Post table, there is a blank field on the far left ...

I have a form that filters between two dates and need it to work with a text
field that I have made look like a date.  The text field is in a linked table
that I can't change the field type.  
The linked table has a field called CollectionDate that is 14 digits in the

I have a report that is grouped by lawsuit type.  Example Civil, Class
Action.  In the lawsuit_type footer I have a count that counts each group.  
The current label is Lawsuit Type Count.  Is there a way so myb label can say
Civil Count and then for the section with Class Action ...

I need 1 customer per page who may have several records per customer. I
followed a prior thread and made a group header, and set force new page
property to before section. When I open the report it has several customers
per page. If I go to design view and then preview the report ...

I have a problem with rounding up or down when it comes to 3 decimal points.
In the Access reports, there are some data of type "currency". What i found
is that
When reporting to 2 decimal places, the Database report is currently

Hello, can't understand what I'm doing wrong here.. I'm getting a 'The
expression you entered contains invalid syntax' message.
=DCount("[Client_ID]","tblClients","Format([d_received],"mmyyyy") = #" &
Format(DateAdd("mm",-11,[Forms]![frmReports].[txtYourEndDate]),"mmyyyy") & "#

Has anyone experienced the following error: "The format specification for
'xxxx' is invalid.You can't save output data to a file in this format until
you correct the setting for the format in the Windows Registry. Run Setup to
reinstall Microsoft Access or, if you're familiar ...

Have a problem in an inherited db.
In the group footer section they have a field OrderTotal which is
"=sum([ExtCost])"
In the page footer section, they have a field whose controlsource is

I have a crosstab query that has year as row heading and month in the column
heading as represented below.  My selected date range includes 2006, 7 and 8
and results in each year with a separate row in the query and "Month 1"
through "Month 12" as the columns: