I have a report with AmountDue and AmountDue2. How can I add these two
amounts together for a grand total at the end of the report? Here's my syntax
for getting the total for Amount Due"
=DSum("AmountDue","[SECU]")

I have a report with two subreports, nothing to link parent to child, but
they do have the same fields to be filtered on.  The user selects the values
from a form that are passed to the main form on open.  However, I can not set
the filter on the subreports at open of the main ...

I would like to have a form that has a list box that allows the user to
select several items.  Then on that form I would like a command button that
runs a report based on the items selected in the list box.  I have a form
named "frmSelectCategory" that has a listbox named ...

I would like to insert a picture on a report based on user input. I have the
user input part working like a charm, but am unsure on how to change the
picture. Specifically I would like to add a bmp file of a signature on a
certificate based on what teacher taught the course.

Is there a way in access 2007 or 2003 to create an instant report or form
that will
convert single record in a table to columnar record (txt) on a results page ?
so that one record of information can be quickly emailed to someone.

Is there a way to indent a detail line in a report based upon the value of a
field in that detail? My goal is like a financial report:
1   Cost of Goods Sold    
           2   Hardware                  

How I can create separate text files for each section of the raport.
My report shows details of parts for each assembly. I need separate text
file for each assembly, with file name to be assembly number.
Thanks for help.

 I'm trying to add the report's name in the footer of my report.  So far,
I've discovered how to add the db name and the path, but not simply the
report name. I am currently adding a label and typing the name, but as we are
developing the report menu, the names keeping changing. ...

I have a report cube build from 25 text boxes (5 x 5) that contain
numbers (with colored backgrounds).
The text boxes are supposed to be adjacent to each other ... no space in
between.  (It looks almost like the side of a Rubiks Cube; but with 5

I'm using Access 2003 and I'm trying to print an address on a letter.  I
have a data field named "mailing_address_apt".  When there's data in the
field, I'd like to have the "#" print in front of the data.  And when there
is no data in the field, I don't want the "#" to print.

I am not sure if anyone can help me with this, but I am trying to figure out
if it is possible to change a Single memo field to to display as columns? Any
help will be greatly appreciated.
Thanks,

I apologize if this is a foolish post. I have tried to figure it out but I
haven't had much luck. I would like to overwrite a local table by pulling a
new recordset from our backend. Users have a local app with a large table
that needs to be updated once every few days.

I have a report that I built based on a from I imported from Word.  The only
fileds I cannot format are the drop boxes.  They are currently showing with
white text and a black background and I cannot align the text in these drop
boxes either.  How do I format these drop boxes so ...

Is there a way to activate a toolbar when a report opens in pop up mode?
I need to open the report in popup window so that it appears on top of all
other objects but in order to print or view in design mode I have to right
click the mouse.  I have a standard toolbar for reports ...

Hi, I have textbox as part of my report, that depending if something is true
or false, displays Yes or No. Because the field is very narrow, all the
report shows is the first letters, either Y or N.
I would prefer to have it display "Y" when true, and blank when false.  Is