this is the test mail

The following query:
SELECT U.User_ID, U.Org,
          NZ(GV.Gap_Likelihood, 0) as Gap_Likelihood,
          NZ(GV.Gap_Impact, 0) as Gap_Impact

Using Access 2000
I know I've done this before and I just can't remember how.
I have a field called Product in a form.  With some suppliers there may be
more than one product.  What I would like the form/field to do is, as I type

I have a form based upon a table in Access 2007.  I change the structure of
the table removing some fields that are displayed on the form.  When I return
to form design view to fix the form, the fields are still diplayed in the Add
Existing Fields window although they can't be ...

Does anyone know the POP3 AT&t WIFI.  Ican send mail but not receive it.
TX, Chuck

I have several command buttons on a form.  I would like to set them off with
colored rectangles and pictures, and allow users to click anywhere within the
area bounded by the rectangle to open a form.
In Access 2003 I was able to add events like Open Form to rectangles.  Is

I'm trying to create a report that is taking from a sales query. the query
has monthly and yearly sales. I want to have the years to be in the report
header such as 2000, 2001,...etc and down to that the related months of every
year.

Access07  In the frontend, a table (linked from backend) will not open when
double clicked.  It presents a parameter prompt for the one field of that
table that is indeed defined as a lookup field - as if it were a query that I
was opening.  However in the frontend the subform ...

I have a report with a GroupHeader called Title Header.  The header has two
fields on it.  It works fine, showing the two fields at the top of each
group.
What I want to do is put the two fields in the Page Header so when the

I need to assign new records a [FieldValue] something like Max[FieldValue]
+1; Except, the next step must begin with the nearest new series. For
example, if Max[FieldValue]=589, then new records should take on values like
[FieldValue]=601, then 602, and so on. The new records are ...

I have preprinted forms that I need to address. My members data is in Excel,
but I can convert it to Access if needed.  I want to address the forms in the
proper spot, then fold and insert to window envelopes.  I want to avoid
printing labels and then havign to stick them on the ...

I have created a form with an embedded subform that will be used to add/edit
records into 2 tables.  One is a table of categories that is used as a look
up table.  The other table is a set of steps that are used in a drop down
menu.  In my form, I am able to add new records to ...

I have a mdb working fine on the PC having Windows XP and Ms Offfice 2000
installed
The same mdb when I am using on PC having Windows Vista with MS Office 2003
installed and I am getting the following warning dailog :

How do I change the starting value of autonumber ie other than 1(Access 2007)?

I changed my email address because of the scam going around. Please start
sending me stuff to this one. diane_tigue_1979@microsoft.com let me know if
you get this.