I am trying to create a select query that will retrieve my specific text
terms only when they are followed by a space.
For example, one of my text search terms is "*hepatitis C*".
I want to retrieve "hepatitis C Cirrhosis" but not "hepatitis Cirrhosis".

When trying to create a query in access using the wizard I get an error
message 'Acive X Component can't create object' this message comes up as well
when I click on the design icon and when trying to use the new command.  What
do I need to rectify this error.  Or will I have to ...

I am trying to select a group of data from one table to insert it into
another one, but I am new using SQL comands and the one I created is not
working, please take a look and let me know what is wrong:
SELECT [Teilnehmer-Nr]

Quite a complicated problem here, hopefully someone's been doing this kind
of thing before...
I'm writing a system for a college that checks whether the course requests a
student has made are valid, or if they result in timetable clashes. The data

good day all,
 I am trying to create a running balance for my checking account
Debit_Credit Field.
 I have been reading about DSUM, but am unsure how to use it? each of my

Is it possible to sort 6-level WBS numbers in Access 2002 or 2003?
Ex: A.2.3.6.5.1
    A.1.6.9.1.3
to

This query works in the query window.  If you name it in control source it
works.  If you write the code into the control source of a form, it gives a
syntax error in the from clause.....  Why?  and can someone help me fix it?
SELECT TBLFUNDINGTOPOS.PosNo, TBLFUNDING.Funding, ...

I want to sort by the "C04" part of the records.  The data connected to the
Datestamp and DateScanned can be a string of entries or just one, with the
"C*" record in it.
Example

My database stores Facilities, the units that belong to each facility and
then the Devices that belong to each unit in that facility. Each device was
used to test patients as well.
What I have been trying to accomplish for about a week now, is a count!

Is there any possible way to design a parameter query using checkboxes?
In a table containing, for example, Publication, Article, and then a
checkbox for each Issue Month, I can pick only the records where the
January checkbox = -1?

I'm importing a table from a MYSQL database that contains a UNIX time stamp
data field. I need a function or a formula I can use in a query to convert
the UNIX time to the Access general date format.

Hi, and thanks in advance.
Is it possible to do a union query on one table with three fields.
Heres my structure.
ID, Surname, MaidenName, Alias.

I'm building a database to give a randomized test based off of the number of
questions I select.  Example:  I have a table with 100 questions, but I want
to only select 20, at random, and have them displayed in a report.  Can this
be done easily?  I already know how to randomize ...

I have following columns avaiable:[LicensePlate],[Expense],[Milage]
I'm trying to build a crosstab query with the expenses as value, Milage as
column headings and LicencePlate as row headings. Now the tricky part.
Instead of the actual milage as column heading I'd like to have ...

I have the following calculation setup as an expression in a query
((([PresentDays]-[C_O_ADJ_DA])/[BID_DA])-1) where PresentDays = 202,
C_O_ADJ_DA = 32 and BID_DA = 200. The result should be -.15 but I'm getting
-.10