X-Posted to MS.pub.Access
In a thread of this same name, there was talk about a 'secondary index'
on a table.  I don't have much experience with secondary indexes and I
don't know if they would help in this case but I'm hoping for some

I know how to create a query using vba programatically. I don't know the
syntax to use this query and open the report.I tried something like this but
didn't work.Ofcourse it was a wild guess -
reports.rptSearchedRecords.RecordSource=qrySearchedRecords

Having major problems trying to return values between two dates.  I’ve been
searching the discussion groups and have been pulling my hair out  for two
days now and can’t seem to come up with how to make this work.  Here’s my
scenario:

I have a query that has a calculated field called PercentToTarget that
divides two fields.  It equals RetailRatio/TargetRetailRatio.  For some
people on the list, they have a target retail ratio of 0.  So everyone who
has a target retail ratio of zero gets a #error message.  This ...

I created a report that is a purchase order.  There is a subform on the
input form where you enter the product information.  When I enter the
information and then hit the button to create the report, the product
information shows up many, many times.  I could have the same record

I put chr(9) or vbtab into a report, and it both displays on screen and
prints out as a little black empty square box.
Can anyone tell me why this is happening and how I stop it.
Thank you.

My customer database includes various customer information (name, address,
metro area…etc.), for which I would like to display in a report for an
individual customer or a group of customers based on specific criteria.  I
currently have the reports designed...however, I would like ...

I have a check box on my form.  Under the main form properties I have a code
IIF([Page1]>0, then
Grant turned in True.
I have the code under current and it works.  

I'm able to print individual labels and sheets of different address labels
from my database, but cannot figure out how to print a whole sheet of the
same address label. Can anyone advise me?

Is there a way to have a report print 3 copies of a particular report
automatically?

I am using the following code to fill in the data for a dynamic crosstab
report.  I have done this before for other cross tab queries but for some
reason, this one keeps listing the values from the first row over and over
again.  Can anyone see what I am doing wrong?  Could it be ...

I currently have a form that contains 4 check boxes and a command button
(generate report), one for each field.
name,address,city,country.
When the command button is clicked, i want to open the report and sort by

Hello, I've been searching most of the morning trying to find anything within
the forum and outside of the forum that would help me with this.  
I have a Main form called - Run_import
I have a sub form called - PRSAdef_New

I have a report that contains a number of columns that relate to scores for
a particular assessment that a person may achieve. There are 7 columns in all
and in some cases a person may score a zero.
Essentailly I want to place an average column at the end of it. I have found

Hi everyone.  I have a very simple report in Access 2000 that people want to
see as they would a similar report in excel with the negative numbers showing
in red.  How?