My Visual Basic version won't recognize Access 2000 when I try to connect the
Data Control to my Access Database.  It does work with Access 97.  Is there
some upgrade I need???

I want to Query a Table using the Query builder.  I want to find certain
words and exclude them from the results.
I was told by a friend to use the following syntax.     NOT IN ("CO","CORP",
"Corporation")

is there a way to find out if the someone is using upper or lower case?
It's for a login window and the Password field must be on Upper caps.
Regards,
Bre-x

I have a column consisting of 4 different items.  Sometimes to compare
certain data I want to select 2 of those items.  For example I have the
following items in column B: Green, Yellow, Red, Blue.  How would I go about
selecting the red and blue items?

I cannot find an emblem of the U.S. Marine Corps or of any other service. I
am making return labels for a retired U.S. Marine officier, and I thought I
would be able to find a Marine Corps emblem to put on them. No way.
----------------

I have a question about how to write a formula to include specific info in a
range of cells.  I have a range of cells I want to include in a formula but I
want the formula to only include the values that I have colored Yellow.  I
could select each yellow one by hand but I want ...

I have a question about how to write a formula to include specific info in a
range of cells.  I have a range of cells I want to include in a formula but I
want the formula to only include the values that I have colored Yellow.  I
could select each yellow one by hand but I want ...

I am planning a database to control lesson courses I provide.
I want to store details of students, available course topics they can sign
up to, location of course and details  specific courses eg: student names
start time location date.

Hi, this is a little bit confusing but I hope somebody can help me!
I have a database tracking specimens from a research project. One of the
fields is 'specimen type' and the possibilities are blood, buccal swab or
saliva. I want a second field with 'blood volume' however ...

My table, students has 4 date fields.  
I want to be able to select any one of the date fields and put a preset date
in it, as the same date will be used in lots of student records but in
different date fields.

I have a question about moving selections.  Sometimes I want to select
certain data in a column based on criteria in another column.  For example,
In column B I have the following items: Red, Blue, green, Orange. In Column C
I have the either a number one or a zero.  I want to be ...

I am having trouble generating a query that will only give the most recent
vehical mileage (vin number) that was recorded on the [tblMileage].  I need
to use that mileage in several other areas.  I need alot of help for this one
I have been fighting with this for awhile.  Please ...

i have a table with 20,000 records. one column includes names. another column
includes multiple dates the person visited a doctor, and another column
includes dates the person visited a hospital. i am only interested in the
last date the person visited a doctor and the last date ...

I just went through an interesting process.  I am evaluating a database
built using Access runtime, using the install program provided by the
vendor, all went well, apparently it installed the runtime package etc.  The
application worked fine.  But, after I uninstalled their ...

Hello All new to access and finding my feet ..
Have created as database with 10000+ entries ... I am trying to create a
Query to idntify erros in a column... All employee number should be 6 digits
so I have creater the query for my new table to show me all employee whos