I am deploying my app to 23 users who all have Access v2002 runtime on their
pc's - bear with me, as I have no security / username experience.  Since I'm
using runtime, I'm not worried about users saboutaging my db accidentally,
because with run-time there is very little they can do ...

In a Query I need to know how many voters voted the last 12 elections of 3 or
over. The lowest number in this field is 0 and the largest is 12. When I
enter the criteria of >="3" I receive all the voters that voted between 3 and
9. I do not get the voters who voted 10, 11, or 12 ...

How do I search a memo field as a partial string as defined by a user entered
on a form using a query?
What I mean...
- I have a form (frmReport).

How do I search a memo field as a partial string as defined by a use
entered on a form using a query?
Here's what I mean...
- I have a form (frmReport).

I have a Table which contains 2 fields. One is acct (text type) & the other
is called notes. (It's type is Memo.)
I need a listing of all acct's which have a 618DI in their memo field. (Thats
a capitol i )

I have a table that has data  by date. One of my fields is a Date field that
has corresponding data for each date. Specifically, I have climate data for
each day of the year from jan 1, 1990 to dec 31, 2004. However, there are
"missing" days in the Date field, i.e feb 2 to feb 20 ...

Here is my sql statement from a select query that queries a crosstab query.
SELECT [test 10day_Crosstab].Dateofcoldate, [test 10day_Crosstab].PMSC_TDS,
CDate([dateofcoldate]) AS formatdate,
IIf(IsError([tds])=True,[pmsc_tds],IIf(IsNull([tds])=False,Round([tds],0),Round([pmsc_tds] ...

All,
Heres an interesting question. In Access 2003 Proffessional. When you run an
update query using values in a 2nd table linked in the query view. Is access
actually updating all the values.

All,
I am updating a MySQL table that is linked using the MySQL ODBC Connector. I
am experiencing problems when updating 1 particular table. I am not updating
entire records only 2 fields on matching records.

I've got a table with a field that holds path information for a file.
I've relocated these files and the current path no longer exists.  Can
I use an update query or another method to change the contents of
these records in that field?

What's the "Not Like" query to ignore data that begins with a numberical
value in a text field of data?

as a criteria in a query I would like to list all records that contain a
particular word or letters in a certain field.

I give up!   I have several tables of budget categories. The tables are
$requested, $awarded & $spent. Each table has the same budget catigories and
are "currency" type fields.
     I have a query with 1 table which places each field in the query. The

I'm having a problem with loading a filter to apply to a subform:
My subform contains a query, which has a list of results. I want my user to
be able to further limit these results by applying a filter.
I can click "Filter by form" and create a filter, I can then save this

   I have a database for storing data from incoming referral forms
These referral forms have 7 different yes/no boxes. I want to run
query that tells me how many referrals have only 1 yes/no box ticked
how many have 2 yes/no boxes ticked, how many have three and so on