When one gets an error in string manuipulations is it possible to just have
access just set it to null some way?

Can anyone show or tell me the basic steps for creating a union query?  I'm
trying to combine two queries by the PN field.
Thanks.

Is there a function that does the opposite of 'In'?  i.e.  something like:
number Not
In(220006981,220002440,220003485,220003092,220001646,220002547,220000157,220001183,220005633,220007178,220000415,210000167,220001600)
I could type out:

Is there an easy way to setup aquery where it will calculate overdue tasks
based on the computer date (I don't want to have to go back in and chage the
statement everytinme I wnat to see what is overdue)  Any suggestions

Is it possible to use single charcater wildcards in "InStr"?
In this case I wanted to search for a "/" preceeded and followed by 2
numerical characters but it didn't work.
May I assume it can't be done or did I just use the wrong syntax?

Hello group,
I need help on the following. I have a table with 8 different columns
all of them are checkbox options (e.g. yes or no).  I need to run a
report which sums the yes and no.

I need to set up a property field for a criteria that is user defined.
I need it to be 'Like' (begin with) and I know that I would need to [Enter
the information here]
But when I put these together it does not work.  Please can someone help as

Excel has a cell formula called Product() that can operate on a list
of varying size.  Basically I'm looking for the equivalent for an
Access query.  I haven't found anything, and it seems like such a
simple function.

I have 11 date fields. The dates are various stages of project completion.
Some construction projects are just starting and some are right at the
finish. Managers put dates in a form when each step in the process is
complete so that we know where we are on each project. The table ...

I have a select query where I am doing a left-join with two other tables, but
the query output is almost double the number of records in the table I am
querying.
Does anyone know what could be happening?

Is there a way to have a user enter a parameter and have Access search for
that parameter in multiple fields?  Example:  A vendor information table has
the ability to store up to 3 products the vendor provides (Fields are Product
1, Product 2, Product 3).  I want to have the user ...

I am using Access 2002 and using SQL Server 2000 tables.  I am trying to make
a simple calculated field that aquates Active to the value A, New to the
value N, etc.
I start a new query but nowhere does the option to open the equation editor

I have this crosstab query that is working fine, is there anyway I can
write this query as a select query?
TRANSFORM Sum(dm_spiisumm_local.qty) AS SumOfqty
SELECT dm_spiisumm_local.partgroup, dm_spiisumm_local.region,

How can I update multiple tables (3) from one linked Excel file.  The update
query seems to be designed to only handle one destination table.

I have a query that has a field that pulls out some data from another field
by the following statement
WIDTH:
Mid([PART_ID],InStr(1,[PART_ID],"W")+1,InStr(2,[PART_ID],"A")-InStr(1,[PART_ID],"W")-1)