I have a field in my table called Job Number. This number is a ten
digit number in which the first four digits of that number represent a
certain client; the other six numbers represent other information about
the job.

I have a table Which has three fields MotorOneOn/Off, MotorTwoOn/Off and
MotorThreeOn/Off.  Each one of these has an option to for On  or Off.  What I
need to do is to be able to run a query that will give me the results of all
three on or all three off.  Not all motors are on or ...

Hello;
I am designing a Query By Form as suggested in KB 95931
There are 11 different fields on the form which will be used in the query
criteria.

In MS Access 97, I am trying to design an update query that will update a
field (SICKTIME) to 0 if another field (STARTDATE) is between 1/2 (January
2nd) and 5/1 (May 1st) in the same year as another field (ASOFDATE). The user
enters the ASOFDATE in another part of the process so ...

Hello,
I am building a criteria expression and I'm using a Val(string) expression.  
When I click Run, I am getting a data type in expression error. I have
confirmed that the field is of type 'text' and in fact all entries are

I am trying to export a query to a .txt file. I can't get the number field to
right align. Any help would be appreciated.

I'm using the following which is working very well except it not working if
there are no spaces in the text of the field.  Can someone help?
MAILING_ADDRESS_2: Trim(Left([Mailing_Address2],InStr(1,[mAILING_aDDRESS2],"
"))) & " " &

I have a form where a user can search by Company and Plan Code, they can
enter criteria in both or leave one blank.  The problem I am having is that
if a user searches only by Plan Code, they should see all items matching that
Plan Code no matter what the Company is, even the ...

Hi Folks,
I'm just wondering if there is a way to create a crosstab query to create
date ranges from today as column headings and quantity buckets on row
headings.

I have a combo box on Form1 that I want do a requery to data displayed in a
subreport on Form2. Here is my code.
The error is "access can't find Form2"
my code in the after up date event in the combo box

I am amending an Access database that I have taken responsibility for so I
dont know all the intricacies of how it was build.  There is a form that has
a custom toolbar which includes a couple of buttons that appear to run
reports . The reports have as their source queries, which ...

I get the DIVISION BY ZERO error when running this query.  The only thing
that changed was this query design:
OLD:
Specificity %: 100-(([Sum Of SumOfTrue (-)]/([Sum Of SumOfTrue (-)]+[Sum Of

I am attempting to do an audit trail of Nursing homes.  I have a
patient who is in one nursing home, then they move to another nursing
home.  How can I do a history on a form for this.  I have crated a
subform, so that when you enter a nursing home it will enter it on the

In my query I'm selecting 3 fields from a table but when I run the query it
returns all fileds from table.  When I view the SQL it shows
SELECT Tbl_DRA_2005_2006.School, Tbl_DRA_2005_2006.Counter,
Tbl_Tenex_2005_2006.Race, *

I use "Find Unmatched Query Wizard" from MS Access 2002 Wizard and give
me only one choice to pick "matching field" between two tables.  I have
12 tables that have 20 columns.   I'm looking for your help to give me
an example of looking all 12 tables if there is any changes from any ...