I am trying to come up with a percentage on 2 text fields.
I have two text fields [Insurance] and [Diagnosis].  I need to know what
percentage of the total records come from each different type of Insurance
and each different Diagnosis.  

I am trying to run a query that excludes records with specified IDs (OppID)
in this case.  Everything in the query seems to work except for the following
part:
AND ((Won_May.OppID)<>"VER-MB65-0393" Or (Won_May.OppID)="RED-JM35-8869" Or

I have a new database that I created that has 8 date fields for each record,
along with other fileds for name, address, etc..  I created a query that will
search for dates that are within a 30 day range of today's date.  This query
then creates a report that shows these dates ...

Can anyone help make this more efficient:
SELECT Orders.OrdersKey, (Select Top 1 OrdersHistory.OrderStatus From
OrdersHistory where OrdersHistory.OrdersKey = Orders.OrdersKey Order By
OrdersHistoryKey DESC) AS LastStatus

I have a two text field that has time values.  The values in these fields
have two digits for hours, a colon and then two digits for minutes.  So 1
hour and 30 minutes would be 01:30.  45 minutes would be 00:45.  I am trying
to add these values together.  So for the first records ...

I am running into to problem with Access 97.
I have two queries.
In query2, it calls query1 which I joined to another table.
within query2, I used some VBA functions, mid() and right().

I have renamed a field to "Jan-05". Everytime I save, close, and reopen the
query, the field name changes to "Jan-5"! How do I keep Access from removing
the 0?!

By default Access opens one windows for your database view and one window
for each query that you have so right now i have the database window and 4
query windows open. So in my taskbar Access have 5 seperate window icon
things taking up so much space.

I have a subform named Equipment that has data with a one
to many relationship with data in another subform named
IPAddress.  I have an OnCurrent event set in Equipment to
update the IPAddress information. When a requery event

I have two fields, a start date and an end date. Could you please tell me
how I can work out how many days in each month based on the start date and
end date.
e.g if the start date is 4th Jan 2005 and the end date is 12th July 2004. I

I have just converted a replicated d.b. to a regular one by importing all
of the object except the tables, which I brought in using the 'make table
query' method suggested in other postings. I am now retesting the forms,
which I have inherited, and I have encountered the "Item not ...

I want a query to filter in only the fields that have nothing in them in a
specific field.  How can I do that without making it numerical.  I tried  
=""  

Here's the situation.  I have a table that has an ID field as well as a
Comment field.  Now all of the ID fields are valued except 200, of these 200
null fields, the ID I want is sitting in the Comment Field, but it's not in
the same location in every comment.

I have a subform (frmAddress) that is used by two main forms (frmRider and
frmFilteredRider).  In the record source, I have a WHERE condition that looks
at the ID field in the main form.  Is there a way to write the WHERE
condition so it doesn't care which main form is open?

I am trying to come up with a percent on 2 text fields. I have two text
fields [Insurance] and [Diagnosis].  I need to know what percentage of the
total come from each different type of Insurance and each different
Diagnosis.  I created a Qry with the Group By then Count funtion but ...