i have a table with "client_id", "ethnicity" and "date".  the client_id field
can have duplicates as the table only holds temporary information based over
a period of time. if i count that field i get a result totalling the number
of records.  what i want to do is count the ...

My knowledge of Access is pretty limited, but so far I've managed to
get through with minimal help via these groups, but I'm stuck again
and the only way out is to learn about making Queries from scratch
or ask you guys. (I'd pay an expert locally if I could find any).

I received some excellent help on friday with a Top 12 query I am
working with. It works great except that I am having trouble creating
criteria to force the results to return 12 values even if the last
results are tied.

Hello ....
I am running the following query:
SELECT a.Area, a.Day, Nz(b.DayTime,0) AS DayHours
FROM AllDates AS a LEFT JOIN DayTimeHours AS b ON (a.Area = b.Area) AND

I am trying to write a query to calculate the date of a report three
days after the admit date.  The report cannot be due on sat or sun so
if the third day falls on a sat it will be due the fri before and if it
falls on a sun it is due the following mon.  I have this code started

I am creating a schedule database based on the Monday date of each week.  I
have a table that has each monday date as one of the fields and then another
field called # of slots that tells us how many customers we can schedule that
week.  When you select the monday date on the ...

I have the following query:
SELECT tblAMUWork.ID, tblAMUWork.DateRcd, tblAMUWork.TypeOfWork,
tblAMUWork.MISNumber, tblAMUWork.RptName, tblAMUWork.AmtRcd,
Nz([CompletedAmt],0)+Nz([CompletedAmt1],0)+Nz([CompletedAmt2],0)+Nz([CompletedAmt3],0)

I have a form and a sub from. one of the fields in the sub form uses a
parameter. I want to use a value from the main form as the parameter in
the sub form. Can you help?

I would like to have a parameter in my query but it uses the like on
the parameter. If I want to select ABCD and ABCC and ABCE I will insert
in the parametr field ABC and it will use a sql statment
like "ABC*"

We carry out Quality Control by either of two methods on each of our jobs - a
phone call for certain types of work, a mailed questionnare for others.
I have dates for each of these in my job history table and form, where users
record either the date that a phone call was made, or ...

The column labels (headings) naturally reflect the field names.
How can I edit these as in some cases they are longer (wider) than is
necessary for the data to be displayed, making the columns wider than they
need be and causing the query to fall off the right side of the screen, ...

Some nice people gave me the following query to create a list of the
highest score in each of the Categorys overall for my sporting club.
SELECT *
FROM [Your Table] as A

I have table with a hyperlink field in it. Is there a way of updating the
address of the hyperlinks on mass.
Thanks
Matt

I can't believe I'm having this problem, but I've been struggling with it all
afternoon and I just can't figure out the problem.
I have a database that tracks (among other things) training. This set of
tables records information about training sessions (Training_NonDoc), and

I have a query result looks like this:
Sect    ID
1418    7002
8018    7002