I am trying to generate reports with a text field that will vary in line
count dependent on the changing number of text lines used for each record. I
have never used Visual Basic or the expression builder before, so please
explain in very simple terms. Thanks.

I'm new to access, I've done database work before just not with this package,
I have only one small problem and this should be an easy one...
Without going into too much detail, i have a report that generates a list
and calculates a few totals based on a date range inputed by a ...

Help! I have set up a database to monitor cost prices of materials and over
the last few years I have made multiple enteries of the same products so that
I can track a history of pricing, so I might have say 7 records all the same
only the date and price would be different.

I have multiple subreports in the detail section of a report which prints out
daily items entered into a case management program which I designed.  Most of
the subreports span the entire width of the report, and are lined up one
below the next.  However, I am trying to place two ...

Thanks again to Duane for his invaluable concatenation function.
Here's a follow up to concatenating text between a master and child table
with a 1-many relationship:
My child table uses a lookup table for its values; When I use the

My email client is Novell Groupwise.  I have some Access reports that I need
to be able to email periodically.  Has anyone figured out code that would be
needed to be able to do this?  I found a couple of modules written by Dimitri
Furman, but there is little explanation as to ...

I have a predetermined amount of txt boxes on a report (26 to be exact). on
the form I have two txt boxes one called "txtFrom" and The other called
"txtTo".
Wha t I want to do is to enter two dates not to exceed 26 months from the

I have a report that has the information set-up in tables. However, whenever
I try to publish a report into word, the tables and the heading/title
disappear.
What can i do?

Say I'm grouping by a persons Name in a report and they have all thi
information with their name. Is there a way to have the report put eac
grouping onto a new page???
Also, with this report and each grouping is there a way to assign a ne

Ok, have a report with
page header
      header #1
          header #2

In my query I have two fields totaled in a field:
Expr1:format(DateDiff("n",[Start Time],[Stop Time])/60,"fixed"). I want to
be able to Group on the report by Job# and Sum the Expr1 field for each job.  
The wizzard doesn't give me the option of Summary and when I create a text

Hello,
I have a report, how can I count and print the number item
in the report?
Thanks,

I've looked at the below statement too many times and I can't figure out why
it won't work.  I've tried using AND as well.  I have 10 regions broken out
by west, central, and east.  I need it to pull all the regions I specify and
count the number of wins.  What appears to be ...

I have an access database with three tables:
<pre>
[Master Table]    [Drug Table]     [Action Table]
*Protocol     ---- Protocol   ----- Protocol

I am very new to Access as the following question will prove.
I have declared some public variables and wish to display them on a Report
Form.
What syntax do I use?  I know I need to create a text box - but what do I