I have a table that contains the following fields:
Date, BatchID, Charge, Description, Amount
I want to create a comparative report show the sum of all transactions for a
particular date in one column and the month-to-date results in the next,

I created a dynamic crosstab report (from
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q328320).  On its
own, it works perfectly.  But my intention for this report is, as a
subreport.  Upon embedding it into the main report, it no longer displays (in

I have an envelope report based on a query with a parameter.
The parameter connects the form that contains the command button with the
report.
This is so when the user hits the command button an envelope for the record

I have crosstab query which the columns on it are dinamic (the amout of
columns depend on the data that comes)
Now i need to build a report based on that query that the amount of columns
changes.

Hello, I have a subreport on in a report's header section. The Link
child/master fields are empty and everything is set to visible. There are no
events connected with the subreport. The subreport records (30 of them in my
test sample) are visible in print preview, but do not ...

using VBA how can i copy a record from a query and then paste it into a table
as a new record

At work we use an Access database (badly designed IMHO) which contains many
different reports - about 25, I think. Various organisations use this
database. They are required to run each report, write down the result
(actually a percentage)on paper , then type up all their ...

Access XP 2003 - I am moving our school student reports to Access. one of the
reports that we need to do are called Year2net. Unfortunately they use an
image instead of a grade on the printout. I need to setup an image to change
on the report based on a Ture/False control. eg. ...

Hello everyone, I am really new to Access, so forgive the rookie question(s).
Here's the scenario.
My whole goal is to print out shipping labels to those people w/ addresses
from a certain category in Outlook.  I have a list of 1000+ contacts in

I have a report that has fields for both client billing address and
job address.  On the form I have billing city and job city and both
have a combo box with data from a cities table.  I have used combo
boxes on the reports and it works but would like to use text boxes (to

im try to make across  report in access database
its a cross table that means there is a headers and rows like this
-----------------------------------------------
Activity        |   S   S   M   T   W   T   F

I have a report which lists employees and the shifts they worked. I want
each employee on their own page, as this page will be given to the employees
each week with their payslip.
If I put a page break in the group footer, it causes a blank page at the

discovered today that you can't export an access report with photos to any
"useable" medium - by useable i mean i need to export the pictures so that i
can generate ID cards from them.  I've tried Stephen Leben's reports utility
and although i ended up with the pictures in Word i ...

Hello again, I have a report based on a query (qrynewmem) which displays all
the members that have joined in a given month, there are 2 types of members,
Circuit and Elite (memtype). At the top of the report I have text boxes to
count the total number of new members, and the number ...

Hi, I need to do something after user printed a report. But how can I know
user clicked "Print" and the report is successfully printed? I cannot find
event such as "Printing" or "AfterPrint" to write code.