I created a form which opens only as a pivot chart.  Is there a way to copy
this pivotchart to Word without using print screen? (I need a clean copy for
use in a report.) I've tried importing but it only brings over the pivot
table & copy is not available when the form is open.  ...

Hello, i am trying to run this query bellow and it says that its too complex.
can anyone help please! little of background on the query. i am trying to
update current data in table with data in a query that's made of other
queries. i tried appending the data from the same query to ...

I'v browsed this group for an answer to this, with no success.
This is my situation:
I need to end up with the number of days during a given month on which
the total number of residents ("Occupancy") meets or exceeds 90% of

I have got a annoying problem. I ran a query that has columns named
ID, Sales Order No.,Selling Date, Product ID, Item description, Selling
Zone. In the table only Product ID has unique value others have multiple
values. Each time I ran a query some of the product ID starts ...

I'm still getting used to Access and needed a little help.
I have two tables with virtually the same data and i was wanting to compare
them using an SQL query so i can see what data is missing?
Is anyone able to help?

Here's my data:
Workstation ID  Product Name  Version
87878787          Word              2000
87878787          Excel               2000

Hi,  I have a table with the following fields:
Manufacturer
Model
Value

I am using VB6 as a front end to an Access97 database.  My computer has
Access2003 and won't let me edit the columns, tables, etc.  I can add/change
data, but not the underlying structure of the database.
I have found & modified a VB front end that will allow me to add/drop

I have a table: Vendor Tech Tasks which is an export of an Outlook inbox.
I need to extract the Task ID, and Route, owner and the url to different
fields so as to make the table more user friendly. The field the data is in
Contents is rather large, and follows the general format ...

I have a query that I want to chane one field to a number field. the Field I
want to change is a ship by month fiels. I come from a make table query and
shows up as (June 2007) I and a new field in the query to change the (June
2007) to (6/1/2007)

I want to do the subquery as follows but the left join will not work in
access.  The reason is that I need to have
the ability to use subqueries with joins in the where clause so I can easily
do multiple joins.  Any ideas?

if Me![CheckSalesperson]  has a value and Me![CheckSalesTaxNumber] has a
value the update will occur.
if either value is null then nothing is updated.
UPDATE [ar customer] SET [ar customer].SalesPerson = '" &

In the example below, can a single query using subqueries be created to
extract the lowest MthNbr for the lowest year and the highest MthNbr for the
highest year. i.e.
Table1

Need to select records where a batch is completed
Batch is made up of "Items" which are complete when field [Result] has a
value in it.
I need my query to select batch numbers for which all "Items" are completed

SELECT B.NAME, B.ID, TEST_DATA_1_2.ID1, TEST_2.NAME
FROM TEST_1 AS B, TEST_2, TEST_DATA_1_2
WHERE B.ID =(SELECT A.ID1 FROM TEST_DATA_1_2 A INNER JOIN B ON B.ID = A.ID1)
AND TEST_2.ID = (SELECT A.ID2 FROM TEST_DATA_1_2 A WHERE TEST_2.ID = A.ID2);