Is there a function whereby I can count how many times a character or word
appears in a string or memo field?
e.g. functionname("For Forfeiting Friday"),"F") = 3 (assuming case sensitive)

  I have a table that lists job numbers (JCN) and dates for when each
job went into a particular status as it moved through our laboratory.
AWM is the Awaiting Maintenance field, there are several hold status
fields, an AFD (Awaiting maintanance From Deferred) field, and an ACP

how do i create multiple criteria statements using the same fields for
different criterias and attach to a single form to produce filtered data
based on multiple select choices from the form:
1. date, name, goal

is there a way that I can update a column where the column equals a
value retrived by a recordset.. for example
I have a table
COLUMNS

I'm a little new to Access but I'm trying to slug my way through with
little in the way of guidance.  I'm trying to sum a column of dollar
amounts based on a code in a "Results" column.  Now, I saw various
suggestions and I understand the logic behind them, but when I plug it

Any insight greatly appreciated.
I have 2 tables, both containing a "task to do" field.  
The first table is a listing of all "tasks to do" defining what tasks are to
be done by people who work in a specific job position. (each person has one

I have a query where I need to bring data in from 3 different tables.
EmployeeData (*EmployeeID, FName, LName, Status, Rate)
EmployeeProjectData (*EmployeeID, *ProjectID, *CycleDate, Total Hours)
ProjectData (*ProjectID, ProjectName, ProjectType)

I have an equipment database and a vehicle database. I have a unique field
"types" taht exists in both tables. I'm trying to sumarize "query" them into
one query/table to run reports from. How do I summarize the 2 tables and have
the unit that share the same type show up ...

I searched the group and this is close to what I need help with.
http://groups.google.com/group/microsoft.public.access.queries/browse_thread/thr
ead/3a260818549c7aea/5b8954802149bdfa?lnk=gst&q=sorting+months&rnum=6#5b89548021
49bdfa
But where do I put all the code Kipp wrote??

I have two tables with one to many relation between them. Say, table Book  
has a bookID and are related to a table Author with many authors in one book
like this:
Book: BookID Title

I have a table:
empID
interestID
empInterests

Hello ol wise ones,
I'm using Access 2002.  Two questions to help improve this crosstab query.
Question1: I have combined the fields due_date and task so the column order
would be correct.  Is there a way to keep the sort order by due_date but only

I have a query that produces a Count of Items, by Customer, by Week.
I need a report to show the cumulative total of customers over a specific
time period:
W/E           Customer count

Hi - I've created a parameter qry based on the input of 2 comb boxes on a
form. You click ok on the form, the form closes and the qry displays. However
as this is for non IT users, I would like the qry results to display back in
the form. Does anyone know how to do this please? ...

I had a crosstab query running that has the following sql:
TRANSFORM Sum(unionQueryUpload.Amount) AS SumOfAmount
SELECT unionQueryUpload.intStoreNumber, unionQueryUpload.strDescriptionRevised
FROM unionQueryUpload