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...

Thanks PHV for your input. However, this expression concatenates the data from the records. What I am looking for is an expression that refers to all the year fields so that I can apply a common criterion .

Thanks Lespaul for your feedback. What is a normalised database?

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...

Thanks PHV, How do I select the 30 categories from the reference database other than specifying each one of them as a criterion in a query?

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...

Hello, I combined 19 tables, each with identical fields as follows: SELECT * FROM TABLE 1 UNION ALL SELECT * FROM TABLE 2 . . . UNION ALL SELECT * FROM TABLE 19 I ended with my consolidated table. However I have an extra 18 rows with the field labels. How can I prevent the field labels from...

Thank you Morja, Lespaul and PHV. I finally got this to work and also got an introduction on how to use the "Union" query. I am happy :-> Do you know of any good web site that gives a comprehensive explanation on the use of the "Union" query?

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.

Now I have the following error message: <<Syntax error in INSERT INTO statement.>>

Hi Lespaul, The first union query worked. However, when I ran the second one, I got the error message: <Syntax error in FROM clause>>. Belinda

Thanks for your prompt response, Lespaul. I am new at this and I don't understand what you mean.

Thanks Morja. It worked. The only change I did was to write[2001_Units] instead [2001Units]. Thanks for your input, Lespaul. I would prefer to do this in one step and tried your approach. I got the following error message: <<Syntax error in FROM clause>>. What do I need to adjust?

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...