In an .mdb access database I have stored some queries and reports. The
queries are pass-through queries which connect to an sql server via
ODBC. The reports are mostly forms like invoices, orderconfirmations and
so on.

I am trying to perform a query from four tables. I have one column from each
table in the query. The columns represent registrant catagories: summer,
winter, and fall, and the primary key is the student #. (Summer, winter, and
fall, come from different tables and choices in one ...

How would i find the percentage of trainees employed from the total number of
trainees using queries??
Can anyone help me on this matter??

We have a database where employees enter the time spent each day on a
particular project.  A report is needed to show the total time each employee
spent on each project.  For example
                           John        Mary       Dave        

We use a database for employees to enter the time they spend each day on a
particular project.  Currently, I have a crosstab query set up to give me a
report like this:  
                           John        Mary       Dave        

I have a form that has several list boxes to filter data for reports based on
the selections.
there is a [teamlst] and [opponentlst]
the values that are availaible in [opponentlst] are dependent upon who is

I use a form to query my card sale table. when i use the VP and SVP
parameters, it works fine. but it does weird things and gives a very
strange output when i use the EA and SC fields. With the SC and EA
fields it gives some records with EA and SC in them and others that do

I am trying to use a >6 in my query criteria but it is not working.  I
suspect the problem is values in the column are not numbers.  This query
comes from another query where values are extracted from a string. Is there
a way to format the column of a query to a "NUMBER"?

I have a table which has 4 columbs for the same thing, this is because for
each record there are upto 4 possible outcomes. To generate a graph i would
like to have the data from the 4 columbs to be evaluated as one columb
instead of 4.

I'm having problems posting... sorry if this comes up twice.
I have parameter values set to make things easier for the users...
The prompt pulls Last Name or Emp #.  If the Emp# is not available, is
there a way to search by last name, including suffixes, but only

I'm trying to create a report that restricts results to the current year. I'm
using the following critieria:

The problem is that these reports are run off of datamarts that are cut at

I am trying to create a query that will combine a number of fields in
a text string for output as a report on student progress - the SQL is
below:-
SELECT [Forename] & " " & [Progress comment] & " " & [Behaviour and

I would like to add a field in a query just to dispaly the day of the week
for a particular recor
Thanks

I have a query that I want to do a count of people from various areas. The
table that the query is being created from is a data entry table. It has the
following fields: ID, Training code, Date of training, area (dept.). This
info is entered every week. A given associate could ...

What are the general options that exists in regards to sending an email with
Access?
Thank you,
Samuel