I have two fields that contain dates.  One is date required, one is date
received.  I am trying to create a query that will show the items that were
received past the due date (date required).  I cannot fiqure out which
operator to use or what kind of expression to build.

Hi, All,
I met a problem, when I view report it is fine, however, when I transfer it
to rtf file, all the text in the report has been truncated. Is there anyone
meet the problem before?

I create a report controls from VBA code with the CreateReportControl
function. I would like to use a width which is appropriate for a given font
and fontsize, and a content. I don't want to change the font nor font size,
but the content is from a table so it's lenght are variing ...

I need to display some numbers from a table that are inserted on different
days in a month, in a crosstab report.
The report, has also group sections and sums the numbers in every date
column in the report.

Hi. I have a (first) report that pulls everyone that has
a birthday in a certain month.  Then I created a (second)
report based on the same query to run mailing labels.
Can I streamline by having the first report have a

I am trying to create a formula to count the number of records that show a
comp ratio of greater than 80%.  Comp ratio is a field name and show a result
of two fields already thru a query.  This is what I have in the control
source field=Count([Comp Ratio]>80).

Hello first time poster
My boss recently moved a DB from one server location to another and now it
is no longer working properly. Please bare with me, I am not very
knowledgable of Access and am primarily an oopl coder. I am using Access 97

Version: Access 2003
I am trying to create a report that includes the following fields:
Customer Name
Country

So far, I've seen reports that are directly out of a MADE querry. However,
what I need is a report that is more of a summary
How many students were this kind, that kind... and so forth. I've yet to
find anything that would help me.

I have a HP LaserJet 2200 Series PCL 6. I am trying to print labels in
access 2003.  I can not choose the type of label I need.  

Hey all,
I've got a fairly simple report/subreport set up in A2000. Everything works
OK, with the exception of the fact that the subreport displays on a new page.
The report is set up with an GROUP_ID header and footer (there will only

The database works fine on other machines but on this particular machine it
refuses to produce the report. I have changes the security features to allow
expressions but it still won't produce the reports. Any ideas?

I am getting blank pages between my main and sub-reports. The sub-report is
okay and is only one page long, but the main report does not start until
mid-way through page 9. I have checked the page width and I don't think that
is the problem, but being kind of new at reports, I'm ...

I maintain an Access 2000 database for a 450-member international
organization of musicians. For each record, there are about 30 Yes/No fields
indicating each member's areas of professional interest or expertise
(Composer, Organist, Singer, etc.).

i have table and a query built .. now Im trying to run a report that
excludes a field based on a number eg 3 = cancelled order so i dont want to
show any number 3's from a PAYMENTresult field .. but want to show all other
results