I have a report that is looking at a table.
1 item on the report needs to get a calc'd field in a query. But I am am
having problems pointing the record source to the query. Expression builder
in Access 2003 insists on building the following expression:  

Excuse my non-expertise of Access, but I am trying to load a long list
(30,000 "values") to see if any of these match up with those within a table
(table A we'll call it). Table A is linked to TAble B to look at a field
within that table. The common field linked to these tables ...

I need to combine several word documents into a file or folder so that that
folder can be sent as an attachment on e-mails

Good afternoon,
I have letters set up to merge with a 97 access database query. From
my PC the merge is perfect. From my interns PC it does not work at all
and when I try to choose the file path the necessary query is not an

I have a list of customers and next to their name is numerous columns with
amounts in them.  Each column represents a new month. Given a starting month,
which is different for each customer & is entered in another field, I want a
sum starting in that month plus the following 8 ...

I have several reports that are run by queries.  Most of these queries have
date range parameters that must be entered by the operator.  I have one query
that I ask only for a week ending date.  This is driving mgmt nuts because
they are used to entering a beginning date first, ...

In Access 2003, I have a Combo box in a form with one of the columns
formatted Yes/No (the table the data comes from is also yes/no data).  When
the Combo Box was dropped-down, the column correctly showed "Yes" or
"No"...until I installed Office 2003 SP3.  Now, the column shows ...

I have 3 forms. Table 2 is a subform (single form) and can have many records
that are linked to table 1 (single form). Table 3 is a subform (continuous
form) of Table 2 (single form) and for each record in table 2, there can be
many records in table 3.

For some reason, I have one table in a database, where the background is
normal but the font color is light yellow.
I did not think it was possible to do this for just on table. I would like
to change back to normal. Where would I find this setting?

Any pointers on getting Access to batch process credit cards?
3rd party gateway software that might work well with Access?
Validation (should Access do that or let the gateway do that).
Other particular hurdles I may encounter or things I should consider before

I teach a database course and I've been using the same databses for a couple
of years for lab exercises. I have had no success converting them to v2007.
Where are detailed instructions for this, esp. w/ regard to macros and VBA
code?

Several weeks ago, we successfully transferred our database from SQL Server
2000 to 2005.  Below are our steps in transferring the database from 2000 to
2005:
a) Backuped our SQL Server 2000 database

I’m building a query that I would like to sum quantities of a part numbers
used on multiple Purchase Orders
Example
PO    Item #         qty    sum

When trying to build a relationship betweet two tables, I'll received the
error message "Invalid Field Definition "ID' in definition of index or
relationship.  I have checked and rechecked the 'ID' field, but can't seem to
locate the problem.

I have a subreport which is based on a query.  When I run the query it
delivers the fields ordered by date descending, as requested.  When I run the
(sub)report, all fields are delivered but in date ascending.  Any clues or do
I need to post more specifics?