I've read through the existing threads but can't find an answer to my
problem.  I'm creating a macro to email a report in snapshot view.  However,
ALL of the reports are included instead of just the current report.  Is there
a code that I need to enter in the "conditions" column ...

I am getting the following message on the form whenever I try to do anything
to the form (ie. add date, find date,etc.) The message is as follows: "The
changes you requested to the table were not successful because they would
create duplicate values in the index, primary key or ...

does anyone know why a report's results would change if the data hasn't.  I
am summing a column of data that is blank and it shows a sum (should be
zero).  Now it doesn't (sum is zero)  Unfortunately the report was submitted
with the sum incorrect.  The report was ran.  changes ...

I have a report that has fields such as Product Name,
Ingredient, and Notes.  I have arranged the report to be
tabular with the labels on the left side and their values
on the right side.  The problem is that the Ingredients

This is a little tricky:
I have two fields: F1 and F2 each are formated Date/Time "01/01/2001 4:30
PM" and "01/03/2001 4:35 PM" respectively. I want to know, can I get what the
time difference between the two fields? The answer would be 48 hrs and 5

Hi I have a database that prints letters to customers, however we would like
to be able to use duplex printing to print the same letter on the back in
Spanish for our Spanish speaking customers. My question is in regards to the
header and footer of the letter, how do i get the ...

I have a Sunday School data base that has a form set up with many tabs that
are the children of the families in our church.  I have numerous reports that
I would like to print (name tags, parent tags, letters, etc.) that I would
like to print directly from the open subform.  How ...

How do I set up my database fields to display a certain color for that field
when I preview Reports in Access?

I have a report which has a field called Profit.  I have
inserted a subreport with also a field called profit.  I
am having problems when asking to add totals separately.  
It adds the main report profit, but I do not know how to

I have a macro set up that will email my report but I need to know how to
email the report automatically based on a date. For example: I am sending a
permit out to be reviewed - I log the permit to a person and the date I send
it. I want Access to look at the date sent and send a ...

I have a report that was working, but has acquired a weird "feature" since
I've worked on it a bit.
Report has Report Header, Page header and footer, detail section, which is
one row high.

I am trying to write calculate the difference between the last and first
values of a table for a report.  How would I do this?  Thanks

I am using an RichText control (RICHTEXT.RichtextCtrl.1) for the help
function of my ACCESS 97 application.
I want the user to be able to print the help topics, which can be a few
lines or several pages. For this I made a report for printing Help topics,

I am using access to do payroll (tracking hours only) and I have a report
based on a query (the query prompts you for a date range).  1 field sums
hours for total hours, 2nd field gives regular hours, 3rd field gives
overtime hours, 2nd and 3rd fields are using an iif statement ...

1. I have check boxes included in a report and want to
remove the borders and just leave the tick.  How can i do
this?
2. I have provision on a report for up to 6 childrens