I need to create an update query that will count the number of fields NOT
Blank and enter the result in another field - "Eq Count".
Field Names "Wheels", "Chassis A", "Chassis B", "Chassis C".
If all fields have data the result would be 4, if one is blank, the result

I have a table "Items" of orders for items such as gift certificates.  I
transfer the gift certificate orders to another table "GC" which becomes the
log of gift certificate numbers and the unused balance of the certificate.
My problem is sometimes a customer orders two or more ...

I am trying to create a query that will show values from two tables
regardless of which table supplies a value and which supplies the null. The
two tables have a common fields- Category and Amount. The Category values
should match a corresponding record in the other table if one ...

MS Access question is further down, the beginning is an overview of what I've
been doing on the server side.
I have a stored procedure in Sybase ASE that is linking to 2 databases which
are on the same server (Its T-SQL so it would be the same on SQLServer). The

I have an excel file with phone numbers.  Some are international.  It is a
text filed in Excel.  Whenever I import them into Access, access changes them
into an exponential number.  When I reimport them back into excel from access
it stays as an exponential number which is a ...

Hi all...
When I run this query,
Expr1: IIf([EmailTo]=1,[Work Email],[Personal Email])
I am prompted to 'Enter Personal Email' and it returns just the work emails.

I have a select query linking 3 databases.  Customer, Fillers and Service
Select query has a field named service which is filled with dates.
I added this formula in the next coulmn field to the right of the service
field.       Year([service])  then 2005 in the criteria field.  It ...

Hello.. I have a table that keeps the jobs worked on daily by employees,
meaning the employee id may appear more than once each day.  I have created
the following code in a query to give me the unique count of employees who
worked during the month:

WE ARE A SMALL HOTEL BUT WE RECIEVE SENSATIVE EMAILS FROM TIME TO TIME.  I
WANT TO PASSWORD PROTECT THE EMAIL PROGRAM SO THAT ALL EMPLOYEES DON'T HAVE
ACCESS.  HOW CAN I DO THIS?

Can a new Field be created that would be 1 if FieldA is less than zero, 0 if
greater than or equal to zero ?
Thank you in advance.

I have two tables. One of them is called tbl_CATS while the other is called
tbl_Contacts. I have a field called LastName and another Field called
FirstName in tbl_Contacts and I would like to match this with tbl_CATS
Username.

I have a query that counts the number of checked boxes.  It totals the
correct number of checked boxes, but the numbers are negative. I've tried
changing the format, etc.
Here is an example.

I've created a query to be used for a Word mail merge. Today each ow in the
resulting query contain; a customer name, a customer agreement number and
about 40 other fields. Since most customers have more than one agreement my
query typpically looks like this;

Database is like this:
Price    NBB
4.51    4.5
0.37    0.35

Good Afternoon,
I have inherited an Access database and it contains the following
formula on a date field:
Between DateSerial(DatePart("yyyy",Date()),DatePart("m",Date())-2,1)