I have a join table that makes a relationship between the "Employees" table
and the "Training" table. The tables are named:
1. Main
2. Employees

I get     "You tried to execute a query that does not include the specified
expression 'Expr1/Expr2' a part of the aggregate function"    as an error
message in my totals query when I try to divide the numbers in one column
with those in another column.

I have a table describing cables and their connectors on both ends.
The cables may have same or different type of connectors on the ends; let’s
say male-male or male-female.
The fields of the table “Cables”are formed as “CableID”, “CableType”,

I am trying to get access 97 to do a running total query without much success.
I posted an earlier question on the subject, but the solution still did not
work:
http://support.microsoft.com/newsgroups/?dg=microsoft.public.access ...

--------------------------------------------------------------------------------
I need help.
I have several Excel formulas that I need to use in Access. I am no
sure just how to do it. What I need to do in Access is find th

I'm trying to count the number of checked check boxes I have in m
table.  I can display the records with checked boxes, but when I try t
count them, the query runs, but don't get a number.  Here's the SQ
Access wrote for me:

Hopefully someone can help me with this issue.
I am trying to produce a report based on a query but I am not sure if
have the structure of the table and/or query set up correctly.
I have a table called Students that has ID, LastName, FirstName an

I have created a select query and one of the fields in LastName and another
field is HrTotal
I want to give the user the option on a form to select wether the report is
sorted by

i know the command to make a query but when i do so i think i must have
missed a step with access cause there is no reult

I'd like to create a "search" type query similar to those you'd find on a
website with a drop-down list. The field in question is a lookup in the form
but I want the user to be able to select from a drop down list in the
parameter query prompt.

I'm adding a new column via this statement:
ALTER TABLE myTable ADD COLUMN myColumn YESNO DEFAULT YES
And it works great except that existing rows have myColumn = FALSE even
though the default is TRUE (new rows behave correctly). I would expect that

I have a select query that looks up values from a table based on a control I
have in a form. In the query, one value's datatype is Double, and the other
is Text. The criteria I have in the query is under Text where it looks up the
value from a control on a form. When this criteria ...

Hiii dear friends i have a problem with update Querry i have a table that has
many fields but Date_Of_Birth and Bonus are two fields of them. so in
Date_Of_Birth i have obviously different dates of birth of the people and i
want to give bonus 200 to all those people whose age is ...

Hi...I would like to know how I can check to see if someone has actually read
an email that I have sent them.Would be great if someone could help....

I have 2 date fields eg date1 and date 2.  I would like to create an
expression in access query with if and else statement to count the number of
day diff between date 1 and date 2.  
If the expression   WTime : (sum(4-([date 1]-[date 2])))   is positive value