I tried the following to add new record:
1)use query
2)use recordset to add record, then assign value to the field by field
At the end, Access always pop up a 'Write Conflict' message box to ask me

I have a simple query that uses 3 fields. Location, Person and Value. When I
group by location and person and sum value, I get all the results I need but
I would love to see subtotals for each location. I'm using Access 2003. How
do I add in the subtotals. Something like

Query 1 has some code that calculates a due date - Date:
IIf([tr.....[ReceivedDate]+30).
Query 2 has only "Date" from query 1.
I create a report with query 1 and the dates are fine.

I have a table of student ID's (numeric) courses and marks such as
shown in this example:
ID           Course              Mark
123456    Math 11            80

If I have an Hospital admit date and a hospital discharge date, I would like
to calculate the number of DAYS between them.     How many days they were
inthe hospital.    I have a DAYS field, but cant get the right combination to
calculate the days.    Very sorry to be so ignorant ...

Most of my tables now carry the Primary Key number in certain tables for
selected data in CBO. I need to extract the actual text that is associated
with the number listed in my table and show it on my reports. I know it can
be done in a query but don’t know how. Can someone help ...

I am receiving an error message that reads: Operation Must Be an Updateable
Query.
I am trying to update the field MAX CHARE DAYS TOTAL.  This field comes from
a previous query where this field itself was calculated by the query.  I have

Thought I would provide a better explanation of what I need to do:
I have one table with all company invoice records for a month, each record
has a field [REP].    
              We have 20 different sales reps [REP] and that will vary from

I have two tables.  One that has ComputerID and some other fields.  The
ComputerID field is unique.  I also have another table that has a non-unique
Computer ID field and a SWName  record for each software program installed
on that computer.  What I would like to do is find out what ...

With some help from John Spencer I've come up with a query that does exactly
what I want...  except that when I use it as the row source for my combo box
in a form, I cannot select the specific record I want.  I'm guessing that my
selection criteria aren't specific enough, but ...

I have three lines of criteria in a query that are working in ways that for
some reason don't make sense to me.  I am creating a retiree database and I
need access to not include those who have the status of the spouse and
retiree as cancelled.  When I specify Not "CANCELLED" for ...

I posted two questions onto the system:
Query of excluded items
CrossTab Query
but I cannot see them or find them with a search!!!  The system sent me an

I have done some internet research that offeres subqueries as a
solution for my problem, but the efficiency is not good.
I have a table with UNIT_NUMBER, YEAR, PERIOD_PROFILE.
I want a query, preferably using a user function, to sequentially

How do I get the actual text that is associated with the number (primary key)
I recived from my CBO in my table? I need to show the actual text and not the
number in my report. I know this can be done in a query but I cannot get it
to work. Trying for 1 hour now and its time to ...

I am unable to view my post.  Is anybody else having the same problem?