I have a query on 2 tables where
Table 1 (tblTAZ-SKIMS) = ALL start and ending nodes (arcs) with their travel
times (3 fields)
Table 2 (tblFacilities) = ending nodes of specific places of interest (1

I need to return the max value of field "b" and the associated values
for fields "a" and "c."
My query looks like the following (where "2" is the average of all
responses for the given question):

I would like to write an If statement with the AND operator in a field in a
query.
For example: I have a total yearFee, and have to divide by 12 and fill them
in each monthFee (field). The starting month and ending month are varying for

I've seen some posts about this before, but the suggestions didn't work at
all when I tried them (probably my fault).
We send a newsletter out TO PEOPLE WHO SUBSCRIBE to it (we are NOT spammers,
and include opting out options in every mailing).  Again, we're not

I am trying to get an understanding of how Access handles transactions.
In my application, I have a couple table for "tracking" transactions.  For
instance, consider you are adding a new employee, updating employee record,
or terminating an employee.  Adding a new employee ...

I have an Access database with two tables, a Client Details table with
Client ID as the key field, and a Client Visits table with Record ID, Client
ID and Visit Date fields.
I have created a Most Recent Visit Date query, with fields Client ID (Group

I have a group totals query with the following
Period (group by)
Week (group by)
Dept (group by)

I am trying to write a query in Access 2000 and would appreciate some
guidance as to how this should be approached.  I am at a very basic
skill level.  
My goal is to create a query that determines what type and size of

Need assistance with query behavior.  I have a field (field 1) on my form
that is based on a query to get a location.  I want another field (field 2)
on the same form to return the location information based on what I select in
the first field and enter the ID from that record ...

Hi,
I have a large Access table with data organised as follows:
Field1: Code
Field2: Date

How can I set the COunt to return ZERO when there is no item to count instead
of returning NO Value...
I Need Help ASAP.

I have a large data base that is used to print mailing labels...
I need to sort the zip codes in a specific order (not accending and not
decending).
Example:    zip code order might be 23101, 19234,43688, 30245, 71403, 28409

I have some mediacre fee shcedules that contain "CPT Codes" which contain
codes that have several different fee's associated with them.
Example:
CPT CODE

Have a small problem. I wish to do thh following:
I created a ranking by ranking the scores and named it RANKID.
RankId  Name   Score
1             JOhn      100

got small problem got one text field that produces 3 text numbers that can
vary in size.  ie. 33,41,101
I want to use the split function to create three new fields.
My Split function is currently: