Is there a way to make multiple sorts work in a query.  There are three
fields I wish to sort on, datDate, txtCode, txtCompany.   I would like to
have the output in  atDate order, Accending.  Then within the output, I’d
like to have the codes sorted, there are three types, X, Y, ...

Can somebody please help me with this expression.  The table is
tblClassification, and the field name is "Class".  The records in the table
in the Class field are, "Students", "Teachers" and "Bus Drivers".  I want to
write an expression called Students and have it count all the ...

I have an Access Database 2000 to track performance. Within the db I have a
performance table where user input their ID, date, part#, side, start
sequence &
stop sequence daily (there can be two entries per day). Then on another

I'm looking for an easier way of setting up a query in Access.  I know how to
do the following in Excel, but I don't know how to do it in Access and I am
trying to imrpove my Access skills.  Basically, if I have a list of data as
such:

I have a query that returns the details for a failure record during a
specified time period. Where if I search between 1/1/08 and 1/31/08 the query
returns the records of all failure records during that period. The row shows
the part number and the total parts failed for that ...

I have a query that find duplicate scans for a certain day, but it the
duplcate scan occurred today and was scanned on a previous day, I only see
the single scan for today. I would like to know when the first scan happened.
I have copied the SQL for the duplicate scans. Please ...

I have a table that I am trying to use a query to sort by Phone Number.  Some
of the records have no phone number, when I sort ascending it gives me the
records with no phone number first and then the populated ones.  I would like
to have it sorted with the nulls at the bottom.  ...

I have a database set up listing first and lastname and then keys that people
have check out. Each key is in a different column but listed in the order
they were checked out . This means Joe may have checked out key 58 in column
1 and Sally may have checked out key 58 in row 8. ...

I have a database to log details about staff in my school. I have a tables
for staff details, courses, absence, educational visits etc.
In each table I have a date field to show when the member of staff is not
present.

When I use the query design view, I have to increase the size of the table
window (from which I'm selecting fields) sideways and vertically to see the
field names more clearly and that also means moving the criteria grid further
down the page to make room.  Is there a way to ...

I have a simple query
SELECT [Tbl Contacts].First, [Tbl Contacts].Last, [Tbl Contacts].Notes
FROM [Tbl Contacts]
GROUP BY [Tbl Contacts].First, [Tbl Contacts].Last, [Tbl Contacts].Notes;

I created several append queries to append to add previous day data every
morning. But, how can I build validation to the query so that I or anyone
can't append the queries more than one time a day (which will create double
the data)? Thanks

I have two tables in a database that have to use four fields for a unique
identifier and primary key.  How do I set up a query to set a relationship
between those four fields together as one?  When I add the tables to the
query I see the fields, but I am not having any success ...

I want to know if there is a possible way of doing this.  Your help
would be much appreciated.
I am able to do the count by each sport.
Baseball         23

I have a table in the following format:
ID     Diagnosis    Fraction
1      X48            0.01
1      Y52            0.5