Hmmm, how do I describe this?  Springfield-1 and Springfield-2 are
"territory" names.  Each of the 'Springfield' territories are defined
geographically by a combination of Counties and Zip Codes.
(e.g. Chester county is in Springfield-1, Harris county is in Springfield-2,

I am using Access 2000.
i have made a table with three columns, one which has the date. I have a 3rd
party application that automaticly writes to this table i have made everyday.
How can i keep my data sorted starting with current date descending to the

I work for a small homeless shelter.  I have a table called "Services"
that contains records with a ServiceID, GuestID, ServiceDate, and
ServiceType. Such as:
ServiceID (key)   GuestID  ServicesDate   ServicesType

I am trying to create the number of packages to be shipped based on the
total number of items that are shipping, and breaking them into bundles of
25.  Therefore, 1-25 items would be 1 package, 26-50 would be 2 packages,
51-75 would be 3, and so on.  How would I be able to have ...

Private Sub Form_Load()
' Turn the MouseWheel Off
Dim blRet As Boolean
' Call our MouseHook function in the MouseHook dll.

I have 2 tables.
Table1: All new trades, (ID, Name, Amount, Remarks)
Table2: All trades from before till now (ID, Name, Amount, Remark).
---------------------------------------------------------------------

I need to create a query or queries, that return the number of matches on
corresponding fields in two tables.  Table 1 is Applicants, Table 2 is
Mentors.  Fields A1, A2, A3..., M1, M2, M3... are populated with a/b/c/d type
values.  I think it should be fairly simple to find the ...

       I have a Query which has the following Fields.
COMPANY
ARRIVAL
DEPARTURE

I have a table. All dates are listed in "Numeric Value" (ex: 20080315).
I'd like to convert thse numeric-values into a standard yyyy-mmm-dd format.
or just convert them into "month" (mmm) , for example,
03 should be March,

I have a table with time in this format "12:00:00 AM".
I 'd like to extract the time in these two formats
1) 12:00   (12-hour)
2) 12:00   (24-hour)

I am having some trouble writing a query where I can match records with
similar but exactly the same content.  For example I want to watch times with
second or five second differences...  What is the best way for me to do this?

I am trying to write a query to do the following. I have data that
looks like this.
Record_Number  Status                    Created_on
2001                  NOPO pMDO          1/1/08

I'm having a problem with the following query being used on an access
db on my website:
SELECT Distinct (videos.id), Videos.*, chi.airdate FROM Videos, chi
WHERE Chi.video = Videos.id and videos.promoter is not NULL UNION

If I have a record that contains a field that is a type-code and another
field a number, is there an expression that will allow me to state if certain
information is present in one field of a record, then change the quantity to
a negative value?  

Big Query Problem
I have This Fields In table1 (Design View)
ID        Autonumber PrimaryKey
ClientName      Text