I posted a question some time ago about the need to use data from one field
in a different field.  I got a great start, but I'm still stuck.  Here's what
I have so far:
UPDATE tblCaseInfo INNER JOIN tblContacts ON tblCaseInfo.CaseInfoID =

MS Office 2003
I am not a programmer
I want to append record from tblContactsV1 to tblPatientV1.  tblContactsV1
has autonumber primary key; tblPatientV1 has a single primary key

Here is a type of problem that has plagued me for way too long.
Let's say we have an account charge table that holds charges for an
account.
Table: AccountCharge

This is the situation:
I want to add a sequence to a group of records in a query that meet
certain criteria. Example:
GroupID            AreaID            EmployeeID             SequenceNo

I have the following fields:
rep           orderack
Blue           Y
I would like to be able to count all of the orderack everytime rep = blue

A while back, I had a corruption issue, and without me realizing it, the one-
to-many relationship between related tables was deleted.  Now, when I try to
reset the relationships I get an error message that states that record(s)
violate referential integrity rules.  I suspect that ...

I am trying to delete entries out of a table (call it Error Log).  The
criteria for deleting entries is complicated so bear with me.
I am comparing two tables (Input and Storage) and seeing the discrpancies
with them.  Right now, I generate error messages that get logged into the

I have been struggling with this query for a while and need some help
from the experts!
I am trying to extract unique records from the following sample list
RefID    QtrDate    TargetNameTargetID Value

I input data into a table that looks like this...
ID#     Class    Mark     SpecID
1         Bio          80        A
1         Phy         60        B

I have two groups of which I want to calculate the 90P for two different
processes (A and B) by week.  I am trying to show the last value of
the top 10 % sorted in desc order for each group and process/week.  I've
tried doing this through a subquery with not much success. Not to ...

I  have been trying to find some information about storing query sql strings
in a table and calling upon that string to run query's dependant on user
selections in a form.
I have a split database and I want the users of the front end to create

I've created a query, but when I run the query Access replaces the
words from the table with symbols like these: 녓, Ꝝ, 鬊, 豅, etc.
Does anyone know how to make Access stop doing this and show the
actual text that I'm pulling off of the tables?

Is there a way to have a query that meets certain criteria also display the
previous and next record that don't meet the criteria?
Let me give a hypothetical example to explain this.  Let's say I have a
table of client names, address, etc. that is in no specific order.  I use a

I work for a small UK charity and we have an Access 2003 database with
addresses and tick boxes recording whether people in the database want
information on various services (Eg fire safety check, benefits info). I
want to be able to print out a letter to send to people in the ...

I am strugling with a rounding issue in a query.
Example:
List price = $1365.00
Mulitipler = .425