I am working on a report that uses the following column: "Number of teachers
currently in same school". In my database I have a table that tracks the
schools that each teacher worked at and the start and end dates that they
worked there. To find out if a teacher is currently at ...

I want to set up a query that groups records by all possible responses, not
just all present in the data base.  In particular, the data in the field is
recorded as blank, 1 through 30, 77, 88 and 99.  I want to create a query
that returns the number of records for each value, ...

I'm sure this is simple,  but im relatively new to access.  this is what I
need to do:
I have multiple customers who use different shippers I need to pull up first
a customer by combo box,  and then  a second combo box to select shipper and

I encountered the above error when I have a form running the a query created
in design view.
My form (frmUserLogin) is actually a login form, taking in username and
password from the user. I have a table (User) which stores the username and

I've been stuck on this problem the whole day and haven't found anything in
the newsgroups to help (maybe i'm looking in the wrong section?!). Anyway,
here goes:
I've created a form whose default view is "continuous forms" becuase I want

I am trying to build a Query that uses 1 table to give Daily Temp changes
The table has daily temperatures for 22 cities.
Fields:
City     Temp   Date

I can't manage this: I have a table with one column with five records.
e.g. A1,A2,A3,A4,A5 I want a function to  calculate A5-A4, A4-A3, A3-A2, A2-A1
Bill

Is it possible to set the SQL as the default for designing queries?
Or to jump straight there from the database query listing?
Many thanks,
Nick

Please help with the following:
I have an employee history table with the following columns:
EMPLID, EFFDT, ACTION
As an example:

I have two tables, one is a list of business opportunities and the other has
all events (meetings, e-mails, etc.) that are related to the opportunity.  I
want to print a report that displays the business opportunity and only the
last event that occurred (the user enters a date ...

I had a query using between Dates and user(user name is created as First name
and Last name), it is working perfectly.  What I want to do is: run the query
but be able to type just a few letters of the username.
Help me please...

I am using Access when importing text files (with addresses), I've created a
number of queries to handel the data but one problem remains. Sometime I
receive national German characters that is ok or might be received as a ; or

I have a query that I recieved alot of help with from this discussion board.
It works great, and Im greatfull for the help I got. The problem now is that
if the field its using is empty it expression will not work. Can anyone help
me change it so it will deal with null fields ...

I have an access 2003 query that looks at our general ledger data and
crosstabs it into rows by account number, columns by month. Everything ties
out perfectly in the query itself. When I build a pivot table view, all the
cents are dropped and dollars only are displayed and ...

I have the date field set up for long dates but when I run queries it sorts
by year then month. I don't care about the year I just want to report on
months.