473,387 Members | 1,520 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Combine n Number of Rows into Column

hariharanmca
1,977 1GB
Hi,
Is there any query to combine the incremental rows to incremental column in MS Access.
Jan 31 '07 #1
7 2773
NeoPa
32,556 Expert Mod 16PB
Please look in this thread and consider adding those items necessary to give an answer.
(POSTING GUIDELINES: Please read carefully before posting to a forum).
You should at least explain what you're referring to when you use the term incremental.

MODERATOR.
Jan 31 '07 #2
NeoPa
32,556 Expert Mod 16PB
Hi,
Is there any query to combine the incremental rows to incremental column in MS Access.
I'm very much guessing here as I'm really not clear what you're asking, but could you be looking for a Cross-Tab query?
Jan 31 '07 #3
hariharanmca
1,977 1GB
I'm very much guessing here as I'm really not clear what you're asking, but could you be looking for a Cross-Tab query?

Yes, Can you give some Examples about Cross tab query
Feb 1 '07 #4
hariharanmca
1,977 1GB
I'm very much guessing here as I'm really not clear what you're asking, but could you be looking for a Cross-Tab query?

Conceder, I have three tables
Expand|Select|Wrap|Line Numbers
  1. 1.    Item Master
  2. 2.    Category master
  3. 3.    category rate master
items in item master every item have different rates according to category group which is in category rate master.
Ex Data :
Expand|Select|Wrap|Line Numbers
  1. Item master
  2.  1. Item1
  3.  2. Item2
  4.  
  5. Category master
  6. 1. Category1
  7. 2. Category2
  8.  
  9. Category rate master
  10. Cid  Iid  Rate
  11. 1     1      120
  12. 1     2      150
  13. 2     1      500
  14. 2     2      650
I want show the details like

Expand|Select|Wrap|Line Numbers
  1. Item Name    Category1Rate     Category2Rate
  2. Item1           120                      150
  3. Item2           500                      650
Feb 1 '07 #5
NeoPa
32,556 Expert Mod 16PB
I'm sorry but I have little to no experience with Cross-Tab queries. Hopefully someone else will be able to help you better with your problem.
Feb 1 '07 #6
NeoPa
32,556 Expert Mod 16PB
I was speaking to one of the admins the other day and they were considering putting together a tutorial on Cross-Tab queries shortly. When they do, I think we should both go and read it through ;)
Feb 1 '07 #7
MMcCarthy
14,534 Expert Mod 8TB
You could try something like this ...

Expand|Select|Wrap|Line Numbers
  1. TRANSFORM CategoryRateMaster.Rate
  2. SELECT ItemMaster.ItemName
  3. FROM (ItemMaster INNER JOIN CategoryRateMaster 
  4. ON ItemMaster.IiD = CategoryRateMaster.IiD)
  5. INNER JOIN CategoryMaster
  6. ON CategoryMaster.CiD = CategoryRateMaster.CiD
  7. PIVOT CategoryMaster.CategoryName;
  8.  
Feb 3 '07 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: Egor Shipovalov | last post by:
I'm implementing paging through search results using cursors. Is there a better way to know total number of rows under a cursor than running a separate COUNT(*) query? I think PostgreSQL is bound...
14
by: imani_technology_spam | last post by:
I have the following table; CREATE TABLE ( IDENTITY (1, 1) NOT NULL , (7200) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NOT NULL , CONSTRAINT PRIMARY KEY CLUSTERED ( ,
5
by: Antanas | last post by:
Is it possible to combine multiple rows returned from select statement into one row? SELECT NAME FROM TABLE1; I want all names to be combined into one row seperated by commas.
7
by: Mintyman | last post by:
Hi, I'm working on a system migration and I need to combine data from multiple rows (with the same ID) into one comma separated string. This is how the data is at the moment: Company_ID ...
8
by: sqlservernewbie | last post by:
Hi Everyone, Here is a theoretical, and definition question for you. In databases, we have: Relation
0
by: ajitha123 | last post by:
I've 2 rows similar with only 1 or 2 columns different. now i need to combine these two rows in the excel sheet with comma separating that two column plz help me
2
denny1824
by: denny1824 | last post by:
Hi everyone, Here is my problem. I have a Table Variable (I could easily turn it into a Temp Table instead) that will sometimes have rows that are identical except for one specific column. The...
2
by: kagweh | last post by:
Am new to Access so go easy Each serial number has several comments made for it and what I need is to combine all comments for each serial into one row separated by a comma or l. Now here are...
1
by: bcr123 | last post by:
Hello. Could you please help with following problem in Microsoft Excel: I have thousands or rows of 5min data that I need to convert to 15min and later to 20min data do some calculations. ...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.