Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-16-2019, 05:38 AM   #1
digit
Newly Registered User
 
Join Date: Jan 2003
Posts: 44
Thanks: 0
Thanked 0 Times in 0 Posts
digit
Same ID in a row

Hi i have table like this :
ID SIZE 1 SIZE 2 SIZE 3 SIZE 4
1 12 14 16 18
2 12 16
3 14
4
5 10 12
I need to be like this :
ID SIZE
1 12
1 14
1 16
1 18
2 12
2 16
3 14
4
5 10
5 12

I know that this is very easy but im new. Can you help me.

digit is offline   Reply With Quote
Old 03-16-2019, 06:23 AM   #2
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 9,790
Thanks: 428
Thanked 841 Times in 800 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Same ID in a row

Here!

http://www.niftyaccess.com/normalization-tool/
__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Old 03-16-2019, 06:26 AM   #3
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 9,790
Thanks: 428
Thanked 841 Times in 800 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Same ID in a row

By the way, I give The Normalisation Tool away free as an inducement for people that sign up to my Newsletter.

I've actually already got a free download coupon code for it which is:-

IHaveSubscribedToYourYouTube

Download it HERE:- https://sellfy.com/p/l24j/

and as the coupon code suggests I would be very grateful if you would subscribe to my YouTube channel. When I get to 1000 subscribers I get a "LEVEL UP" and access to more useful features on YouTube!

__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)

Last edited by Uncle Gizmo; 03-16-2019 at 06:37 AM.
Uncle Gizmo is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 12:37 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World