I have the following code in a form.  
DoCmd.OpenReport strReportName, acViewPreview, ,
strCriteria, acWindowNormal.
It works fine on all of my user's machines except for

Is there any formula I can use to calculate value?  I know
can calculate average, sum, and total count. There should
be a formula to calculate 75 percentile value. Am I right?
Thanks for any advice.

I have Access XP FE and SQL 2k BE.
For the past few weeks, one report has been running just
fine....but then yesterday, the person who prints it out
noticed an anomaly.

Is there a way to have just a single word in a paragraph printed out in
italics on a report, without creating it as a seperate text box?

I see "Right" and "Left" in the list of built-in functions, but when I try to
use them they are unrecognized and are treated as run-time parameters

I've got a table with contact information (phone, address, etc) on a
number of people, and just need to get a report that displays the
total number of people in each state. Basically a report that says
"from table y, there are ___ people from Alaska ... there are _____

I have a report menu form that opens a particular report depending on the
selection made from the listbox control on the form.  Before the report
actually opens, a report dialog box opens to allow the user to enter criteria
for the report.  How can I program the caption of a text ...

I'm having trouble creating a chart in Access.
I read the help instructions which say to put it in a form
or report.
So I tried this, doing and insert chart while in a form.

how are variables used in iif within a control source.  
when i use a variable and then run the report it askes for
a value for the parameter with the variable name.
seeker54

How can you get the results of separate queries in the
same report?  The wizard could not combine them.
I had to create successive queries to get the end result I
was looking for, then used the last query for each

How can I delete a sub-report out of my main report?
Thanks!
Tina

I want to highlight various tasks which have not been completed by a
particular date.  I have a yes/no box to indicate it has been completed at
form level but want the system to do some 'smarts' using the current date etc
when a report is run.

Can you let me know how I can add further sections to an Access report,
thanks nick

I put a subreport in the details section of the main
report, but when I go to print preview or print the report
it is gone.
I have data in the subreport and it is set to visable.

Having problems trying to get my head around the following.  Want to show if
a task has expired or not been completed on time.
I have included a tick box (yes/no) which if ticked would indicate that the
task is completed.  But want the system to show those task that have expired