I have created a make-table query that works just fine. My problem is I
do not want to see the pop-up message asking:
"The existing table 'name of table' will be deleted before you run the
query.

Hi NG,
I'm trying to make sense of some data I have imported to Access from various
sources.
I have one table with two fields; A and B.

Hello again:
I have a query based on a single table.  The query has a date field which
receives parameters from a form (Between [date1] and [date2]) and multiple
calculated fields (mostly Count fields).  

I have a form in MS-Access 2003, that has 2 date field.
1. Date Survey Sent
2. Date Received Survey Response
I maybe stating this wrong, so please forgive me.

I have just started some work on access and currently i am stuck on 1 query.
I have a list of accounts alongwith project start date in below format:
Sr. No.  Account  Project Start Date
1           ABC         1-Apr-05

Please help, running out of time!  I am so close, (yet so far away).  My
goal is to end up with a query of all fields of the records with the earliest
delivery date for each buyer of each style, sorted by the earliest date.
Like this

I am trying to use an update query to copy data from one column in a
table to another column in a different table. Both fields are called
DESCRIPTION in both tables. The two tables are linked using an auto ID
number generated by one table and have a one-to-many relationship.

As usual, I'm stuck with another problem that I can't solve.  I have a
table called MainTable (see below):
MainTable:
Loan  RevDate

I've got a table I'm trying to update with data from another table.
The table to be updated has multiple columns but I'm concerned with two:
DEPT     OLDACCTNUMBER
There may and probably will be duplicate values across these columns but not

My hunch is this question will make clear at least one basic concept
of Access 2000 that is escaping me, but I'll put vanity behind.
Besides, maybe if I get this to work I'll get the concept(s), too ...
I have a db. promo_tbl, with names and addresses and four columns.

How would I run a parameter query that prompts you to type the first
couple letters of a last name, and will allow the entire name to be
retrieved?

I see many types of posts regarding the problem of averaging null values. I
have made it work for my queries, except it won't work when all the values
are zero.
The following is averaging three values. If all the values equal 1 or

I'm trying to create a calculated field (STARS MATCH)in a query using the IIF
statment. Examples of the fields and the data in those fields is shown below:
Field name=ORG, data=PD5
Field name=JON, data =PD5AB or PD59Q

Hi,  i have two text boxes with iif statements, basically both are (iif
[cost] <> 0, [cost], " ") then on the difference column where I compare
the two costs i tried inserting a condition that iif
((([cost1]<>0,(iif([cost2]<>0,[cost1]-[cost2]," ")" ")..however i

HELP! I'm at wit's end w/ this beast; thank you for your help. Any assistance
with this particular project would be much appreciated, and also any
recommendations on good Access books for beginners.
I have 2 tables, one for Athletes, one for Injuries, which have the common