Search results for query: *

Hello, I usually have four or five workbooks opened at the same time. How do I create a macro that will: 1) Add a new window to the active workbook, 2) Arrange the windows horizontally, 3) Switch the view to "Full Screen" and, 4) Minimize all other workbooks. I am also looking for the...

I have a table (Access 2002) with five fields: Product, Year 1, Year 2, Year 3, Year 4. There are 200 records. Some products have no sales for all four years. Other products may have sales for one or more of those years. I want to design a query to filter out all records with no sales for all...

I have a table (Access 2002) with three fields: Class Product Sales The database has a total of 30 thousand records. Within the Class Field, there are about one hundred categories. What is the best way of creating a query that filters out about 30 of these categories. There are several records...

What is the best way to append ten tables with identical fields into one table? All records must be kept even if there are duplicates.

I have an Access (2002) table (Table 1) with the following 6 fields: Product, Manufacturer, Price, 2001_Units, 2002_Units, 2003_Units. I want to rearrange the data to use into a Pivot table in excel. In order to have a drop down list for the years in the Pivot table, I want to have the data...