By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,968 Members | 1,852 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,968 IT Pros & Developers. It's quick & easy.

Inserting a new row between existing rows

P: 14
Hi

I'm trying to find a way in inserting a new row between an existing row in an Access Table just like an Excell Spreadsheet. The reason I need to know is because I have information in a table that needs to grouped together an already generated report such as all Activitity Information. What I have to do is to order each category in the table by inserting a number manually in the Order Column in order for the information to be grouped together in the report when I print it out. Do anybody know how to do it?. I have been searching on the web and found no success. Or, is there a VBA code and/or a SQL statement I can use to solve this problem.
May 15 '07 #1
Share this Question
Share on Google+
3 Replies


code green
Expert 100+
P: 1,726
A database should not care about the order of data because we can use powerful functions such as ORDER BY and GROUP BY. Carefully look at the design of the database and the query generating the report. All else failing you could introduce a numbered column to define the order of the rows. I can't believe I am suggesting this.
May 15 '07 #2

ADezii
Expert 5K+
P: 8,619
Hi

I'm trying to find a way in inserting a new row between an existing row in an Access Table just like an Excell Spreadsheet. The reason I need to know is because I have information in a table that needs to grouped together an already generated report such as all Activitity Information. What I have to do is to order each category in the table by inserting a number manually in the Order Column in order for the information to be grouped together in the report when I print it out. Do anybody know how to do it?. I have been searching on the web and found no success. Or, is there a VBA code and/or a SQL statement I can use to solve this problem.
Microsoft Access does not have a Between-a-Row Insertion capability. code green had the correct response, get the data in, than you can use any of the available tools to assist you in creating the proper Grouping Levels.
May 15 '07 #3

P: 14
BNW
Microsoft Access does not have a Between-a-Row Insertion capability. code green had the correct response, get the data in, than you can use any of the available tools to assist you in creating the proper Grouping Levels.

Thanks. I'll try what code green said.
May 17 '07 #4

Post your reply

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