Im a newbie in designing reports with no or very little knowledge in VB. now
im given the task to design an accounting report with data coming from 2
different tables. Any suggestioins?

I am trying to print a Access report on greenbar continuous paper and I
cannot customize the size of paper to print on

I have report with table and each cell is textbox with border solid.  Each
textbox has "CanGrow" parameter set to "Yes". I would like all textboxes
horizontaly to have the same height.  When "Name" textbox increase it's
height  due to longer text, all other textboxes have to ...

Can anyone give me an inpit mask for a long date that will format a short
date entry to be viewed as a long date?

I have a report with a header and a detail section.
Based on the value in a textbox in the header, I want to either display or
hide textboxes in the detail section.
For example, there are 3 textboxes in the detail section. If the value of

I would like to create dynamic crosstab report which will be like this:
                                   |   Year               |
     Customers               |  Product            |
                                   |  Qty  | Amount   |

I have an option box on a form, which has a  print report button, When I run
the report I want the chosen value of various fields to be added to the
report, trouble I am having is adding the code to choose the value I need.
My sample code is below:

I have a report that has the following two fields that lookup a value in the
"Host" table:
Text16 =DLookUp("[FirstName]","Host","[Title] = 'General Chairman'")
Text17 =DLookUp("[LastName]","Host","[Title] = 'General Chairman'")

I have a graph in ms access 97 where I would like to have a "target" line
which is simply a dotted line colored red, drawn on the graph at a set point
"x" on the y axis.  The purpose of the line is simply a visual tool to
quickly show which values are above or below the "target".

We are using a report to print out family cards for our students at school.
Each A4 page contains 4 cards. The number of family members varies between 3
and 5.
Is it possible to conditionally format each 'card' so that families with 4

When I print my report the default printer setup is so that it is always
printed in high quality...
Can I add some code to get a report in draft mode?
Thanks

I'm assigned a task to generate a dynamic report which shows the sales
number based on the month chosen.
The structure of the table 'Sales' is
account, name, $Jan-lastyr, $feb-lastyr, $mar-lastyr....., $Jan-thisyr,

In have 2 queries  A and B. A with following fields: Year, Period,Machine,
Production and B with Year, Period, Machine, Hours. I should like to make a
report with this records and calculate the production per hour for each.
machine. I make one query with A and B as a source for ...

I've recently loaded two new copies of Access 2003 on two old laptops.  
However, I am not able to access Reports on these laptops.  I can't even
create new reports.  I originally did a full install, now I've removed Access
2003 and reinstalled as typical but it hasn't helped.  ...

I have a main report with mulitple subreports. The subreport has a
groupheader with column headers.  There are cases when the subreport header
prints on the main report page without any detail lines.  The detail lines
print onto the next page.   How can I suppress the subreport ...