I've created a delete query using a left join on two tables that identifies
the data rows I want to delete.  However, I get an error message that tells
me too "specify the table containing the records I want to delete"?  How do I
correct this error?

We are tracking how long it takes to complete product changes in a database
and I would like to use the date diff to calculate the workdays or
networkdays within the database.  Is there a way I can do that?  In other
databases I do a weeks*5 calculation (workdays*weeks) but these ...

im trying to create a query where i look up a particular set of dates between
a certain point in time.  for instance i want to look up events that happened
between 12/12/2005 and 12/19/2005.  whats the "formula" that i would use?

is there a way to have a record change color if certain criteria is not
matched?
for example my database has records based on date issued and date recieved,
so if the date recieved is null or date issued+7 days < current system date

I need to subtract the date from Appearances in Court from the next date in
appearances in court. Below is what I tried but it just gives 0 since it
isn't taking the next date. What am I missing?
# of Days: [Defendant Stats with Dates]![APPEARANCES IN COURT

This may be a bit complicated, so bear with me if you can. I will understand
if nobody can help as this has kept myself and my colleague stumped for a
while.
We have different tables and queries from different systems all pulled

For a specific Query (Summary, to get first occurance of a group), when I run
it and/or go into design and then click 'save', I get kicked completely out
of ACCESS.

I am applying the following criteria in my listbox query: HAVING (Table.NAME)
Like("*" & [Forms]![Frm]![Textbox] & "*")
I want show all records if [Forms]![Frm]![Textbox] is empty. But when
Table.NAME is null the record will not show up.

I have an access report exported to a excel spreadsheet. Everything works
fine, but the content data gets restricted somewhere. For eg., I have a
comment field with datatype memo in access, if i export to excel am not
getting the full data exported. I am not sure where am doing ...

Sometimes I need to cancel a query that is taking a long time to run. The
resaon for the cancelation is soimply impatienace, its not that it has gone
wrong.
Control-Break just brings up a dialogue box for caneling any code that is

MS Access 2K, Windows XP
====================
Hi,
I have a query (QueryA) that concatenates values for a field using the

I have a table that contains available options for house construction.  I
have another table which contains the options desired on a certain house.  I
need a query that will show me all the available options not in the table
containing selected options.  Is there a way to do ...

This db is for tracking customer dollar agings. How much is owed to us at any
giving time. All works well, but I am added a field to track disputed
invoices. What I need is if a value shows up in a certain record in this
field, I want it to highlight the complete record in say ...

My query returns records with 14 fields of data.  My problem is that, under
certain circumstances, it will return records that are basically duplicate.  
The first twelve fields are the same, but the last two (message date and
message time) are different.  What I would like for ...

RE:  Access 2002
I have a table that contains 9240 records.  I want to separate that data
into 88 sets of 105 records each.  For example, the first 105 records are for
region 1.  The Next 105 records are for region 2, etc…  I was wondering if,