Hello,
Trying to perform an update with a join & sum in the same query.
Maybe I can't do it in access - but I have to get this to work somehow...
Here's what I have:

I have two very big tables (about 1.500.000 records each) T1and T2. Those 2
tables have a field with many common data. I'll call it F1. What I want is
to add all the data from a field called F4 of T1 to a new field in T2 (I'll
call it NF).

I hope I have posted this in the right place.
I have a query using three tables (see below).  Simply viewing the query is
not an issue, however, when I use it as the recordsource for a form, Access
only pulls up the first 50 records, then the rest after a pause.  This is

I need to delete from file records that are less then 20 minutes apart
leaving the first from records that are less then 20 minutes apart for the
same card and date.  Other entries remain unchanged.   Records are not sorted
in any particular way.  

I am re-posting this as I believe my previous thread has run dry.
I trying to get a weighted average from a union query. The jist of what I'm
trying to do is compare a teams average performance in games to how they are
ranked.

I have a looming report deadline, and suddenly a query I thought I had fixed
shows me it's not fixed. In the SQL below, please please PLEASE look at the
subquery and tell me how I can fix this. When I try to run the query, I get
the error message that I cannot I have an aggregate ...

I created a new field in a query called "Class1" and entered the following
IIF statement.  What I want the IIF statement to do is enter the word
"Footnotes" if the two criteria are met, but not add anything if the criteria
are not met.  The query also returns the first and last ...

I am using a make table query that overwrites the existing table each time it
is run.
I have cleared the confirm boxes under options yet the warning that you are
about to delete the existing table continues to show

There is an add-in program in Microsoft Excel that runs Monte Carlo
simulations (about 5,000 of them at a time).  I have created a database in
Microsoft Access to gather the data I need and compute the means and
standard deviations I would need for the Monte Carlo simulation.

Hey people,
I have created a simplified version of my database for employees off site to
record their hours. I created identical tables so that the data could be
transfered on a weekly basis to the master database through an append query

I am stuck using a database with no primary keys.  :(  I have two tables
that both have the same field name and datatype.  Using Access, in the
relationships design, I can create an indeterminate relationship with the two
tables.  However, since I do not have access to clients ...

I have a table based on telephone numbers and customers.
Field 1: Tele#
Field 2: Customer
Field 3: Tele#2

I want the query to return 1 row for each ORDER- which is unique for each
clientid and ticket#(combined). The order can be based off of a quote (from
quote table) or just input the order with no previous quote made to the
customer- then no quote id.

Hi,
I am relatively new to Access 2003...
I have imported a table with more than 2million records into Access...and
when I create a query based on this table, it gave me the Erro message as

I am needing help. I am wanting to enter a Date of Birth and know what age a
person is on a certain date, let's say August 1st of the current year. Does
anyone out there know how to do this. The expression I am currently using is
something like this: