Go Back  DVD Talk Forum > General Discussions > Tech Talk
Reload this Page >

MS Access quick question

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

MS Access quick question

Old 04-15-02, 12:25 PM
  #1  
DVD Talk Special Edition
Thread Starter
 
Join Date: Nov 1999
Posts: 1,712
Likes: 0
Received 0 Likes on 0 Posts
MS Access quick question

For some reason I cannot remember how to do this.

Say I am doing a report and ends up like this:


Seinfeld 101 episode name
Seinfeld 102 episode name
Seinfeld 103 episode name

How do I set it do group Seinfeld together so it only lists the name "Seinfeld" only once

Seinfeld 101 ep
..............102 ep
..............103 ep

Of course minus the periods, just used those for spacing.

Many thanks!

Last edited by Eternia; 04-15-02 at 12:28 PM.
Old 04-15-02, 12:58 PM
  #2  
X
Administrator
 
X's Avatar
 
Join Date: Oct 1987
Location: AA-
Posts: 10,763
Likes: 0
Received 4 Likes on 3 Posts
You'll need to break out "Seinfeld" and "10x episode name" either in the database or during a query. Then do your grouping on the "Seinfeld" field and tell it not to print repeating values.
Old 04-15-02, 02:53 PM
  #3  
DVD Talk Special Edition
Thread Starter
 
Join Date: Nov 1999
Posts: 1,712
Likes: 0
Received 0 Likes on 0 Posts
Thanks I got it to work!

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.