I've already posted once, but I didn't clarify. I'm new to ASP and ADO so I
need a  thorough explanation of a fix to my problem if anyone is willing to
take the time.
I have an asp page with a form that is used for signing equipment in and out.

I'm trying to create a query to find duplicate records, but some
entries might contain a . or a '. How can I account for this in my
query?
SELECT BrandName.BrandName, BrandName.Suffix, BrandName.ProductClass,

Hi there everyone, as a new one to computers I appear to have a problem, on
start up of my computer it takes around a minute before I get to the user log
in, whereas before it took around twenty seconds. I have used the defrag and
the disc cleanup but it still remains the same. I ...

I am looking for some assistance.
My end result is a report that will display records for a certain
month.
I need to create a parameter query that prompts the user to enter a

This is the SQL from the Design View.
I get an "Could not delete from specified tables" prompt.
This is my first attempt at a Delete Query.
DELETE EmplDB.*, EmplDB.STATUS

My problem is that i have a database with fields linked to each other (some
more than once). But in a particular query i have created showing all these
different fields linked to each other i have reapeated entries (because of
fields being linked to fields more than once). Is ...

Okay, I've seen a few posts about this in the past, but no one seemed to
know the deal, so I'm asking again.
In Access XP, I have 1 empty table and one chock full of data.  I make a new
append query, and whether I try to append one field, 5, or all of them,

Here is my current query*:
SELECT [T-Jobs].JobName & "-" & [T-Jobs].JobNumber AS FullJob,
[T-Jobs].JobType
FROM [T-Jobs]

I have a query that I am outputting to an excel spreadsheet. When using
excel VBA I was making every other line highlited.
The spreadsheet would not keep this conditional formating because Access
saved the spreadsheet as Excel 5. I got around the problem using Excel

Hi there, I know that access-sql supports "union" but what about
"intersection"?
Let' s say we have 2 sql queries and we 'd like to create the intersection
of them.

I ran a query with 42,000 records (rows) I'm trying to output to (analyze in)
Microsoft Excel 2000 running Windows XP.  However, I get the following
message: "There are too many rows to output, based on the limitation
specified by the output format or by Microsoft Access".  Is ...

I have a database with 5 tables. Each table has 4 fields in it:
- date
- region
- city

I have a simple update query that updates about a dozen fields in a table
with current info from another table. This is a simple straight forward query
that has worked fine in the past. Now all of a sudden it gets about 2/3 of
the ways thru and just stops. No error messages. No ...

Background:
I am using Windows XP Pro, MS Access 2000 and linking to tables in a SQL
database.
If I use the same tables to create a main form and sub form, the

Good Afternoon;
Please look at this  IIf statement - I keep getting comma errors!
IIf(cable.FGLAND like 'H*',(mid(cable.FGLAND), 2),cable.FGLAND) AS
CONNECT_TYPE,