Code:
Private Sub Report_Open(Cancel As Integer)
Dim RptValue As String
   RptValue = InputBox("Please type a Wroker ID." & vbCr & vbCr & "To

I have designed a report to print out bank
statements downloaded from the bank.
All works well, but the bank's long
transaction narratives are in upper case

Hello.  I was wondering if anyone could please help with this beginner
question.
Using:  Access 2003 with Windows Xp.
I have a simple table with Name, and two Memo fields.

Dear Group:
After my best attempts, I'm admitting defeat on this issue.
I've got a single table, simple in layout.  Relevant fields to this
issue are as follows:

I have a one to many report based on the FAMILY table with a subreport based
on the STUDENT table.  The STUDENT subreport is sorted by grade (youngest
grade first).  I need to print labels grouped by the youngest child's GRADE
then TEACHER.

I'm trying to create a report from a crosstab query where the column headings
will be dynamic.  The data table has 4 fields:
site- text
discipline-text

Hi I am trying to write each record that matches to a report, but I keep
getting a mismatch or a object required error.  Can someone please help.  
Were I get the error is on line 2.
Thank You, Amour

I am having a hard time grasping SQL.  My project is just about complete, and
I come to an area were my progress has stopped.  My goal is to print a report
showing the sales of our 5 farms.  I allow the user to select any of the
farms to report on, grouped by the farm number.  At ...

I need some assistance on using top values in a query that I veiw in a
report.  Is there a way to first filter by a column then do top values?  Or
does it base it off of the whole thing?

How do I retrieve which listbox items were selected from a form and pass them
as parameters to the report which utilizes an underlying query?

I am getting data from an ODBC database and one of the fields is a date. When
I link the table into an Access database the date comes thru as a text field.
I'm trying to use expressions to do a conditional format in a report based on
the date, but it's not working. I have a ...

Hi all. I have a database with 100 records. Each record has a dozen fields
that can have a numeric value of 1 to 10. I created a query which shows me
all records which have at least one field with a value less than 5 (field1<5
or field2<5 or field 3<5 etc.). The results of the ...

When I click to view report everything is correct except for the line for the
city state and zip.  This is the statement.
=Trim([City] & ",  " & [State] & "  " & [zip])
I can see nothing incorrect about the statement, but a box comes up asking

I create a report with date from the Employee Info Table.
2 of the fields are calculated fields and on the report, these 2 fields are
showing up empty.   In the Employee Info form however, these 2 fields contain
information.

I have a database that tracks the CreateDate for different types of documents
documents (DocType).  These documents need to be reviewed every two years.  I
would like to create a report that show the number of documents that are due
for review each month by document type.  I just ...