I have a group of letters in MS Word.
Want to make similar reports  and use reports to print them.
I would love to import them in Access and make reports from them if I could,
and just insert some fields from queries I need.

I am new to Access and seek your help.
I have a database where I have entered Client Name,
Product Name and associated Funds. Also entered in the
Date on which the Fund value was calculated.

I have a report that is tied to a dialog box form that is
run by a macro.  My dialog box form allows me to select an
option box and then select an area from a combo box to
filter the report (or leave combo box blank to see all

I have 5 identical reports, the only difference in the reports is the text
in the Report Header data in details area is selected from a query with
parameter.
When I call the report a parameter asked for a number  eg 1= agents 2 =

I created the report in Landscape view and it still opens in Portrait view. I
checked the page setup, and it says that it is Landscape view, but the Print
Preview is Portrait and the pages print in Portrait. What can I do to fix it?

Some reports won't print in my Access application.  I can
see them in preview mode, but they won't print.  This
happens both on my local pc and on the network.  My only
solution is to save the report to .rtf and print that

I have two separate queries that don't relate in any way. I would like to
combine the two results of these queries on one report. I have tried to
combine the queries into one but have not been sucessful since they are
unrelated in any way. I'm thinking I want to use a subreport, ...

I have a rather challenging (for me, anyway) reporting requirement and
would appreciate any feedback. In short, I am trying to create a multi
column report in which...for each main record, text retrieved from
multiple supporting tables is appended with the right prefixes and

I added this code to my report ("report page" event)
Image.Picture = "C:\database\photos\" & picName & ".jpg"
where pic name changes for each record on the report, but when I run it the
first record has not picture and the second one has the first record picture.

I have a column in a table linked to a series of
bitmaps.  These show up as a package,  no problem.  
Double click on them and I can view the pictures, no
problem.   When I try to show these pictures on either a

I have a report that can spit out some "Null" fields on the report but i want
to print "Blank" if the field is null.  I thought a IF THEN Statement would
work but cannot seem to get anything to work.  Can anyone assist me with
this?  THANKS IN ADVANCE!!!!

I want to subtotal data per page. It works correctly to subtotal the groups
and the report, but the page subtotal returns #error for both count and sum
functions. I have played with running sum over group and over all and the
best I can get is a subtotal of 0.

I had a report that contained vertical text boxes.
Upgraded to Access 2003 and now the text boxes are empty.
I found a MS KB article (839779) that acknowledges this
problem but gives no solution at this time. Does anyone

I have a report that displays a column of eiter 'yes' or 'no' for each
record. I would like to total (count) the number of 'yes' records.
Tried '=count([Notified]) but that didn't work. What will?
Thanks,

How do you get rid of the blank spaces in the report after
choosing "yes" for hiding duplicates?