I am having an unusual issue.  I did the label wizard to create some name
badges.  I used the label number 5384 from the list of labels which is based
on a query.  The query has about 200 records and has fields such as
FirstName, LastName, Title, and Forum.  Whenever I go to view ...

I would like to create a report that captures all the fields from my MS
ACCESS database that are not entered. If
additional information is required then let me know, and
thanks in advance.

The answer to this question is probably so easy I should be shot for asking.  
I have a number of reports that are set to print with the click of a button.  
Problem is that some of the reports do not contain any information except for
the header, footer and some unbound text boxes ...

I have a text box in a report where the control source is field that
contains either a 1 or a 0. I am trying to setup the format of the text
box to display Fail for a 0 value and Pass for a 1 value but I can't
figure out the syntax for the format. Thanks in advance for any help!

I have a report from a crosstab in which I have month's accross the top, and
percentages by employee as rows. Here is the SQL of the query:
TRANSFORM Avg([PRODUCTIVE_TIME]/[STAFF_TIME]) AS Expr1
SELECT MastrPhoneStatsTbl.USERID, MastrPhoneStatsTbl.LASTNAME,

I have produced a report that is based on a parameter query. I created the
parameter to ask for "town "and "city". I grouped the data in my report based
on another feid. I have also added calculated controls and a chart to each
group within the report. For every chart that is in ...

I HAVE A FIELD IN A TABLE FOR MODELNUMBERS WHICH IS A LOOKUP FROM TABLE
MODELNUMBERS.  IT LISTS THE CORRECT MODELNUMBER WHEN i REVIEW EACH RECORD ON
THE FORM.  BUT WHEN I CREATE A REPORT, IT DISPLAYS THE ID # OF THE
MODELNUMBERS DATABASE.  WILL DLOOKUP CONVERT THIS ID TO THE ...

Hello -
I am new to access.
I have created a mailing list report - but now I want to change the font
size without recreating the whole thing from start.  Is it possible to

I have four fields I want in my report however I want them to self space....
Example (If I just add them to the report)
151   Test Message                        JPrater             10/15/05
151   Enter Message                      Wedwards         10/15/05

  I created a database that lists all my CDs.  I have a report that prints
the Artist Name, CD Title, Track Number, and Track Title.  I have it so it
sorts them by Artist name, then by CD Title.  What I would like to do is have
it print a sequntial number in front of each CD.  ...

I am using "=Format([txtCustTN1],"(000) 000-0000") & "  /  " & [txtCustTN2]"
in a report to display the telephone number from two fields (txtCustTN1 and
txtCustTN2).  It works fine as long as there are two numbers.  My problem is
getting "txtCustTN1" to display properly when ...

I'm trying to export complex crosstab reports designed in Access 2003 to tab
delimited text file, so that the resulting text file can be used later to
import in Excel for manipulation. By using Access report Export facility I
could only export report to space delimited Text file, ...

I have managed (thanks to help from this group) to create a couple of reports
with some simple, but effective, bar charts. However I've noticed that when I
preview the report the chart is not shown correctly on all pages, it's OK on
the first couple but not the later ones. When I ...

I am trying to place two sums in the header of a report.  One sums the values
in a CREDITS field when the SUM_CODE field equals "K" and the other when the
SUM_CODE field equals "B".  
I remember creating expressions several years ago that used a WHERE clause

I have a report which totals transactions then only displays the totals in
the report.  How can I sort these totals in decending value order.
Thanks
Graham