The table
Name  Test Scrore  Test Date
A          99                05/94
A          96                06/99

I have a single form that has data for a single event and within this event
there are several employees conducting this event that I would like to track
the employees activities. What is the simpliest way to go about putting what
I would describe as a data entry table into a ...

       My customer wants me to generate an invoice from data
contained in MS Access.  He has a Microsoft Word - based invoice that
he currently uses and wants the new system to use the same document.
So I intend to use Word Automation and MailMerge to meet the

I have an access db I'm creating for reports.  I need to get the data from
another access db.  I assume I can write a SQL query to this access db to get
the data since its on our network?
I don't understand this bigger db.  It has 50+ tables.  I tried to run the

A file is in the "access 2.0 file format"
How can it be changed to "access 2003 format"?
Khalil

Okay, below is what i have for a text field in a report....
="Performance Information " & [Enter a User Name] & "
for the period between " & Format([Enter a Start Date],"mmm dd"", ""yyyy") &
" and " & Format([Enter an End Date],"mmm dd"", ""yyyy")

I'm trying to print certain numbers between 1 and 100 and when I run it, it
prints all 100 numbers.

I have a rather complex report that is showing weekly data for an employee.  
The report does a great job in grouping by month but I want to average some
on the fields showing on the report and it does this well unless the employee
did not work for one week (Vacation).  Then it ...

I would like to be able to click the delete button on my form (which has a
subform)and have it delete the record and then have the form set to New
Record.
Below is my code but it bombs on moving to a new record New record

I have a form with an Add Record button.
When the button is clicked when first entering the form, I works great.
When the 1st record is entered and the button is clicked again to enter
another record, I get a msg "You cant go to specified record."  I click the

Any suggested reading for Access 2003 VBA?
I have both "Step by Step Access 2003" And "Microsoft Access 2003 VBA for
Dummies" (how Ironic) and niether have been very helpful.

I have a table with 2 major fields showing Debit (+) & Credit (-)
Transactions of a party. I want to desgin a query so that a third column
appears shows running balance as follows:
DEBIT    CREDIT    BALANCE (REQUIRED)

I have a students information database in MS Access.
I have created following tables:
StudentsInformation
FeeStatus

Are calculations only done in Queries (forms, reports) not in Tables?  I
helped someone get totals for their query, but now they want to see it in
their table.

while out of office?