I am currently generating a set of records from a table using a query.  These
are grouped by equipment number in a report (example below)…
Equipment: 1250
02/14/05  repair detail…

I have a list (single column) of countries, Germany, Canada, France, etc, in
a table.  Is there a way to Query those values to filter out "Berlin,
Germany", "montreal, Canada", etc from another, larger, table?  Or do I need
to create a form and do a query by form, if so how does ...

How can I get a value for the total Yeses and a value for the total Nos in a
Y/N field?
Thanks in advance,  Shannon

Can I calculate elapsed time in seconds from four separate start date and
start time/end date and end time fields? I can do it no problem with two
fields - start date-time and end date-time fields but my client wants the
fields to be separate. Thanks for your help.

Here is the Situation;
Table A with Field A, data type = Numeric, needs to join Table B with Field
B, data type = Text.
How do I change the data type on Field B to make the join?

Hi all,
I need a query that will count and place that counted number into the field
I provided. Example:
My table has five fields:

I'm in need of additional help on a query that I thought I had figured out.  
The problem that I got help on before is located at the following URL:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.access ...

Criteria Section:
WHERE (((RESC.func_biz_num)='41322')
AND ((SCH.TIME_FY_DATE) >= '1/7/2007'
AND (SCH.TIME_FY_DATE) <= '1/13/2007'))

I need help with a query.  I have a date field in my db and I need to
identify dates that are not the last day of the month.  
Thanks

Hi Experts,
Here's the environment: A2K, FE on each pc and BE on one PC on the network
I have a table to record forms returned from clients with fields as:
kat_id, firma_id, fair_id as Long, form_nm as text, form_no as Long,

I have a table with user names and security modules. There are 1700 users and
65 security modules that will have a Y or N depending on if they have that
module. I would like to be able to run a query that will group all the users
with the same security .  I cannot figure out how ...

This is what I imported from excel into access:
user name, module, edit, query, add, delete, review... (65 columns in all
with Y&N )
pmayes....... bkin .....Y...... Y........ Y ......N .......Y.........

I am not sure how to get the numbers I am looking for. I have a query that
shows all the records I need totals for. The numbers I need on a report are
the total number of records entered for each OutcomeNumber. Then I need the
total number of "Yes" and "No" for each OutcomeNumber ...

Query1 retrieves data for 2,000 records from a series of linked tables that
have about 100,000 recordset
Query2 retrieves data for 5,000 records from another series of linked tables
that has about a 100,000 recordset as well.

I have a database for managing a review process that has several steps.  The
data are stored in the table tblCAR.  Each step has an employee assigned to
it.  The employee name is selected from a combo box that uses the Roster
table (tblRoster) as its row source.  The EmployeeID ...