I have the following SQL statement attempting to join data from two tables
and place the correct number from
the area (foreign) table in  the contacts (primary) table.
There is a one to many relationship between the contacts.areaID and the

I have a course called AP1 which is sat every 5 years.  When I run an
outstanding course report and a member of staff has worked for the company
for 20 years, started in 1985,  and sat this course 4 times it still shows as
outstanding in 1990.  How do I type in for it to only ...

I have a query that has the following phrase in the Criteria Field:  Like
[Enter a State]
How could I enter multiple entries into this popup search box, and have the
query pull every specified record for each entry?  For example, if I want to

I use Access 2002, my colleague uses 2003. We are creating a spreadsheet and
corresponding database. I've been talking about it in several of my recent
posts. I asked a question about ranking in an Excell spreadsheet and got a
lot of great help. Thanks again, guys.

I have a table with following fields:
VehicleID,Date,CurrentMilage,Gallons,Cost.
What I'm trying to get is the following: VehicleID, Date,
MilageDrivenSinceLastFueling, Gallons, Cost. Please help

We use Jet and ADO to connect to the mdb file from an outside application.
We recently started adding Queries(Views) to the database in order to make
our queries more efficient.
Now, there is a lag when the application connects to the data, and I do not

Good Morning.
I hope someone can help me.  I have 4 tables containing data which all
relate to the same sales order number.
Table 1 - Sales order

We are looking for a way to put an array into a query to use the NPV
function.  Does anyone have any experience in this area?
NPV(rate,array)
THX!

I wasn't sure whether to post this here or in the programming forum
but here goes.
I've been working on a problem to try and plot values into an array o
text boxes, and am really stuck.  I'm hoping some guru out there is u

I have the following table :-
CustID, TrxDate, TrxType, Amount
======================
CustA, 1-Jan-2005, Buy, 1000.00

I would like to sometimes run a parameter query but see all of the data and
not just certain criteria. Is there a way to do this?

Hi, I'm trying to write a querie for a database that lists several clients by
a unique id number.  I'd like to see how many of the clients have purchased
over $500 of services from us, but I'm running into a brick wall with my
logic.  Because each person can purchase at different ...

If I have a query that looks like
[=CANDIDATE]
and I am searching for John, but there are john Doe, John Dillon, and John
Chronos,

I have a query with ship date as one of the fields.
I want the query to list all information where the ship date is blank (not
shipped yet).  What do I use for date criteria that will allow report to
print only unshipped orders?

is there a way of using the networkdays coding in an access a query