In the design query grid I want to match the letters "ABC" anywhere in
the
column 'description'. I could not get instr to work by using:
InStr(description, "ABC")) > 0

I have a field and in the field I want to remove the - symbol where it
appears so if the fiels is 1234-5678 what function can I use to make it
12345678 remembering that in another record it could be 12-345678
thanks

I am trying to import Excel sheet into Access but I encounter with a problem
in ZIP code field. Even through I set ZIP code column with ZIP format in
Excel, when I import it into Access I am missing leading zeros. I tried
another way and created table in Access and set ZIP field ...

I am getting the following error message when I try to run a make table
query. what could be causing this?
Invalid argument. (Error 3001)
You tried to perform an operation that involves a routine in a DLL, and one

I am trying to write an archive for an Access 2002 database. To make this
simple I'll explain my problem as if I am working with 1 table.
I use a make query to select old records and archive them into another
table. Then I use a query to delete the records I just archived.

Query
SELECT tblStaff.StaffName, RandomDateInRange(#1/1/2001#,#12/31/2001#)
AS DateOne
FROM tblStaff

I'm having problems with a form for registering worktime activities. A
user can enter several activities on the same date. In a form, I want
the user to be able to pick a date from a list, with the result that
only activities assigned to that date are shown.

I'm currently the database administrator for a relatively small (less
than 100,000 entries) database. Currently in our field_samples table
we have our unique key a Field_Sample_ID field which consists of a
three letter company code and underscore then a sampling place ID

I'm having trouble with a pair of multilist boxes.  The first (NameListBox)
provides parameters for a query that updates on click.  The second multilist
box (List136) is populated by the results of the query.
My problem is that the second list box does not refresh when I requery ...

I have the follwing text in a table.
10
100
1000

After a join, database has numerous occurrences of a number. I would
like to count the number of occurrences of each number in a frequency
table and if there were no matching numbers, ie a field is null (how
many times does that occur.)

I am using the InStr function in combination with Left to split up a name
field - as follows:
FName: Left([FullName],InStr([FullName]," ")-1)
This works mostly except if there are two names such as Jo Anne, Ann Marie.

How can I modify this part of my query's where statement:
((TblAssyShipments.DateDueSubQty) > (Forms!FrmAssyStatus2!TxtOldest))
to work so that no filter will be applied when the text box TxtOldest is
blank?

I have a query set up for my report that is supposed to return all
records where the Admit Date is before or equal to the selected date,
AND the Discharge Date is after the Selected Date.
In the criteria for the Admit Date field, I put:

I have a table that has the students firstname, lastname, and 40 different
Yes/No fields of courses. If a student completes a course, I put a checkmark
(yes) in that course. My question is how do I query the table to pick all the
fields (40) that have yes in them. What is ...