I am slightly new at access.  I have created two queries that are
finding and summing calculations from the same field on the same table.
So it is the same information, two different ways.  Then i am combining
these two queries into a third query that is just a query to gather all

I have two tables, PARTS MASTER and SALES DETAIL.  SALES DETAILS records all
sales (qty sold) of PARTS.  I would like to generate one summary query
showing all parts sold and the price (from PARTS MASTER) and the extended
value.  Right now we are running a large detail ...

I'm trying to calculate a month's time for billing purposes. I'm having
a hard time with it, and it should be easy. I know I'm missing something.
I want to know how many months it's been since CommenceDate. DateDiff
doesn't work for me (at least not directly) because 11/29/2005 ...

I wrote a simple query to our DB to list animals that are residing i
our shelter.  I pull animal's name, sex, registration number, neutered
and name and address of the person who brought the animal to us (al
unique fields on our DB).

My DB ("Animal") has a field ("Comments") that contains monitar
information in some cases.  When present, it is "Vet $164.00, Copa
$25.00".  (Other, non monitary information can also be present.)
My agency needs to know the total amount of "Vet" and "Copay" monie

say I have
table1 A B C D etc
table2 B C etc
and I wish to remove B and C and others like this from table1.

I have a date field in my query and i want to put into the criteria to select
all the records that the date  in the date field is in todays month - ie the
current month

I have one query called solve rate and one called solve rate 2. The first
one gives me a total number of cases assigned to each individual. The second
one solve rate 2 gives me the total number of records that contain "UNKNOWN.
The third query solve rate computation uses the ...

I have a table with patient chart#'s [Chart] and date of visits [Date].
I want to make a query that returns the [chart] but only the most recent
visit [date].
So basically I would get a list of patients and the last date they were seen.

In a typical school DB situation, some classes have two teachers. At the
moment I print a class roll (list of students) for each class and that is
given to THE teacher. When there are two teachers for the class, this
doesn't work. We end up photocopying the class roll and hand ...

I have two tables that I am trying to build this query on.
One table lists all Organizations that are participating in a program.
We'll call that tblProgram
One table lists all of the forms that organization must submit. We'll

I do have a question about a query on update.  I appreciate if anyone could
help me.
Here is the table I have:
Emp

please, i'm going crazy...anyhow, let me explain...i created a database for
my client.  as such, i have a copy of the database here at my office and a
copy at my client's.  if an update was needed to my client's database, i used
to be able to write the query/queries and make the ...

I'm trying to create a pdf file from a word dokument but I can't install
PDFMaker. Please help!

the idea is excellent
but we are dealing in Access environment
pls explain