Rows to columns
I have a table with three fields
I need a query creating these two columns:
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I have two columns say column A and D which consists of integer values and the values of the columns are say in the range 1 - 100 ( both the columns ). so there is a row say in column A value is 38 and in column D corresponding value is 37.
So now in the output there should not be any other record with having value 38 and 37 either in column A or D .ie. all those rows which contains these values other than this rows should be omitted.
Similarly for other rows and values also .I tried with the following query but didn't worked
Can a 2.8ghz, i7 (not sandy) 4gb system handle this OR would adding more RAM help?
It's going really slow right now making the 1st query from the table with about 85,000 rows and 12 columns. Can't wait to combine that with the 20,000 row database with 15ish columns.
how can I perform basic math on Access db columns? I need to multiply a constant by the present column value ($).
the kicker is also only doing partial rows, I.e. some rows X .96, some rows x .99, etc.
if you could hi-lite rows/columns, then do math would be the ticket!
Between: how on earth could MS build access without this basic function? they want you to buy Excel and import/export!
I know you can colour every-other row, but this isn't what I need to do. I need to be able to colour certain rows or columns
How do I insert the desired rows without moving EVERYTHING on the formdown?
Is it possible to hide the rows only where all the five numeric field collumns have zeros
The important columns are STOREID (store ID), CUSTID (Customer ID), and QTY (Order amount). I want to select 25 rows per store that reflect the top 25 customers in descending order by their order amount values.
SELECT TOP 25. only gives me the top 25 rows regardless of store so I'm missing something.
This means the following;
1. Several rows from output have to be combined into one row with several added columns in input.
2. Criteria for 'merging' rows are based on the values of several columns in input, if these all match the row can be merged.
3. When there are over 4 identical rows in input for one merge, the data from any of these rows is fine. Result in output is limited to 3 extra columns.
4. A final row in output needs to display the true amount of rows in input.
I've added a simplified and shortened example of the two files in question as an attachment to this posting.
My first instinct, based solely on experience with excel macro's; 1. Concatenate the rows that need to be identical for the merger. Save in temporary row.
2. Create a new table. For each row check if the value in the temporary row has been used before, then write the value in the proper column and update the counter.