I have a query that results in a single record.  I would like to tie that to
a text box in a report.  In the past, I have used SQL with VBA behind the
scenes to do this.  Is there an easier way to get a text box to display the
results of a query?

I am trying to get a report to open only if one of three values are true.
This is my query:
SELECT t_Contact.ICNNO, t_Contact.Incomplete, t_Contact.Incorrect,
t_Contact.Missing, t_Contact.Comments, t_Contact.CSR, t_Contact.CSRMgr,

I have a report based on a query.
The results are as follow :
ID     Name      Table 1 ID            Table 2 ID             Table 3 ID
1       JJ               1                         1

I have to create a new Report for my database.
I would like to "copy" the format of the current report for consistency
purposes. The new report comes from a different table and query, all I want
is to make it look like the existing one as far as layout, font, etc... is

I posted this once before and got no replies so maybe this isn't possible.  
If it is not please let me know.  I'll try to reword this so maybe it makes
more sense.
I have a field in a table called "topic" that is hand entered (no list or

I think I have a simple question but I cannot seem to do it.
I have a table which has a field with a row source "Open";"Closed"
I have created a report but I only want it to show "Open" records.
I have tried to edit the layout but that does not seem to work.  So I

I want to export a report that is bound to several aggreagate queries (like
counting the number of students). I have also some header information showing
like Course Number and other stuff.
I tried to export that report to Excel and RTF and when I opened these

I created a one line query that gives me the total Weight scrapped for the
selected month. When I run the query it works! When I try to put that value
in a text box of a report I get #Name? What am I doing wrong?

I am trying to concatenate the first and last name fields into a
report.
For the Control Source in the properties box for the text box
"FullName" I put the following:

I am trying to create a report that sorts by last name.  Each individual has
multiple addresses.  Currently I have the names in the ID header section.  
The report is showing the records for multiple people with the same last name
(it was not when I had the name in a "Last Name" ...

I have a report that I created a year ago in Access 2003, and had some
problems with error 2114..   Installed new graphics filters and it worked
fine.  
The report is a catalog, and uses embedded jpg images so I can print it out

Okay, hopefully this is simple.  I am using two pictures on a form that fill
a void when a subform is empty. I have the properties set to visible=no and
an event set up "on activate": If me.otherexpenses=0 then
me.other-excel.visible=true.  This works beautifully, however, I have ...

I have a report based on a crosstab query which uses a form to specify date
parameters.  Per Duane Hookum's recommendations on other posts I set up the
query so that the column headers display relative dates - Mth0, Mth1, etc.  
However when I attempt to use the DateAdd fuction to ...

I want to be able to print reports that contain only 1 employee's
information.  I have set up a query with a parameter to pull this information
and it works but is there a way to set it up so that there is a list box or
combo box to choose the employee's name from instead of ...

Is there a way to link the data from a table or query to a monthly calendar
that can be displayed and printed.
I have a database with six trainers who are each a assigned classes each
month.  I would like to create a calendar report where we can request the