Is there any way in an append query to specify that you just want to append
one row at a time?

I am attempting to delete items in one table that exist in another using a
delete query and joining the appropriate fields from the two tables. Access
is telling me that it cannot delete from these tables.  Is there another way
to accomplish this?  The first table is used to ...

I'm trying to create a query to give the number of unique clients
served between a range of dates.  Basically, I want count each unique
ClientID in the table "Records", when the Date column for records in
that table falls between two dates in a second table

I have a sales report that is setup from a query with a parameter for date -
Between Forms!frmEntry!StartDate and Forms!frmEntry!EndDate.  I have been
asked whether it is possible for the report to have the period as '06:00 Day
1 to 06:00 Day 2'? Currently the client cannot ...

the following query does not work :
(I am using a generic database access tool to create tables and enter
data into an mdb file)
CREATE TABLE Customers

Listers
I have 2 tables:
Table 1:
Date          Category       Number

I am designing a document management system. Tables of concern are:
1. tblDocument... DocID, DocName, ActiveStatus
2. tblRevision... DocID, RevID, RevLevel, RevDate, LinkToDoc
3. tblApproval... RevID, EmpID, ApproveStatus, ApproveDate

I have a union query (pasted at the end of this message) in Microsoft
Access 2003 that works as long as a second subquery is not added to the
union part of the query.
When the query runs, an error message comes up telling me Access

I have a problem with a query that is returning me a "Divide by Zero"
error when it should not (Talked about this in an other thread). I have
found what is the problem, however I don't know how to correct it since,
I think, it's caused by a bug in Access (I should not say that :) ...

I am using a query to look up an exchange rate (or conversion rate) from a
table of weekly date ranges. I need to find the associated currency exchange
rate for that week where the expense occurred ("[PERIOD_END_DATE]").  
My query formula is below. I can't figure out why it ...

I would like to extract the financial year quarter from a Date.
I am using the DatePart("q",[date]) method on the field.
When I have a date = 01.04.05 the function returns = 2.  But in reality the
financial quarter is = 1.

Can you please help me with IIF statement below it accepts it but it doesnt
run with correct data what am I doing wrong??????
Thankyou what would I do without you!!!!
Kate

I`m gathering emails from my database for a members mail out, but I need to
filter out any emails that contain "@hotmail.com" as these emails are not
accepted by Hotmail when I send out info via Worldcast(bulk email program)
any help would be great

Query:
Age     Gender      Age
Table   Table       Table
Count   Group By  Where

I am trying to write a query to do the following.  I am having a lot of
trouble, because every time I leave Design View, Access modifies my
query.  How would you recommend doing the following query...
I have these 3 fields