Sorry I hit enter and it posted a blank question.
OK I have a Access 2002 database that contains a tabele called "Current
Members" with fields called "Active"(yes or no, check box) and a field called
"experation date" (full date ie: 1/1/2005) and email address(text, saved as a

I want to delete records from a table that are in a list represented b
a subquery.  Trying this in MS Access 2003 produced the following SQL:
DELETE dbo_Products_CategoriesAssoc.*
FROM dbo_Products_CategoriesAssoc, [Fix VTMM-5]

I have an outer join that has a where condition on it.  The problem is
that where the subordinate table has no records, the where clause seems
to be changing the query so that it doesn't bring back a row.  For
example, if I take the where clause off of the query, I get a row for

Here is my problem I need a genealogy search and output from my database.  I
use a unique code for each entry and some are related to one or another.
What I want to do is get the grandfather father and son and if It goes
deeper than grandfather to do it.  So hopefully I explained it ...

Does Access have the capability to "reverse" crosstab? I have a table with
month (from jan to dec) listed vertically in the first column, and the day of
the month (1 - 31) listed horizontally in the first row of the table. (The
upper left cell in the table is blank). All the ...

I have a query that will allow users to search names, with last name and
first name entered separately with wild card through a parameter. How do I
have such flexibility as allowing users to enter 1 to multiple times of
different names through the parameter? The parameter set as ...

I'm currently writing a Windows application in VB.NET using Visual
Studio .NET 2003 and connecting to a MS Access database. The software
checks SMS and Active Directory to see if a software license is
available and, if so; writes the employee's name into tblSoftware for

I am setting up a database to track service visits to customers.  I need to
write a query to compute days between each visit. Since each visit is a
seporate record in the table, I am lost as to how to compute this data!  
(Background - This will be used to generate a report for ...

I have a crosstab query that lists the exhibitors with their square footage
from each show they've been in.  I have another query that calculates a point
bonus for them based on their square footage in the last five shows.  
However, this requires me to rewrite the bonus query ...

I had a query in Access 97, that had a field ID_ORD with critera
[Forms]![Open Picked Orders]![ID_ORD]
If the order number was on the form, the query found it.
I upgraded to Access 2003 and this criteria no longer works.  If I type a

I understand that you can add an asterisk to a preexisting list (Query or
Value List) in a combo box by using a UNION query in the rowsource properties
to append the items already in the list with an asterisk as the first item.
Anyone know how to do this?

I have this crosstab query that is working.
TRANSFORM First(tblAnswers.Answer) AS FirstOfAnswer
SELECT tblAnswers.clientID
FROM tblDataTemp LEFT JOIN tblAnswersON (tblDataTemp.TestNoID =

Using Access and Excel 2000.
1)   I have a crosstab query the we want to print weekly.  I set it up to
print landscaped with .5 inch R and L margins I then saved it.  Every time I
run the query, I have to re-set the page layout, it keeps defaulting to 1

I'm having this problem for a long time, i don't know how to solve it...
please help a poor one!
So, I have one supplier, I'm receiving invoices from him, I make payments to
him and I need to know my debt to him for ex. at 30.June.2005. I made 2

I have two tables  T_Actions and T_CaseNbr.  They are related by the field
“CaseNbr”.  There can be many actions for one
CaseNbr.  The actions are input on a  datasheet subform linked to the main
CaseNbr Form  using Parent/Child CaseNbr.