Grouping Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to make video tape labels and would like to group records together so that all of the titles on the video tape are on the same label. So basically I would like to somehow group some records into one. Does anyone have any suggestions? If I need to create a query I will need to know how to do that because I am not very good in Access. Thanks for your help!
 
You will need a field that says which tape a title is on. You can then group
on this field in a report using the Sorting and Grouping button on the
toolbar. The report could be designed to print the labels for you.

--
Wayne Morgan
MS Access MVP


Melissa said:
I am trying to make video tape labels and would like to group records
Click to expand...
together so that all of the titles on the video tape are on the same label.
So basically I would like to somehow group some records into one. Does
anyone have any suggestions? If I need to create a query I will need to
know how to do that because I am not very good in Access. Thanks for your
help!
 
Hi Melissa,

You haven't given enough detailed information for anyone to give you real
help.

The generalized answer to your question is that you must group on some data
element that is common to the items you want on one label and that doesn't
appear for any other items.

For example it could be a category such as "Adventure" ...

HTH
--
-Larry-
--

Melissa said:
I am trying to make video tape labels and would like to group records
Click to expand...
together so that all of the titles on the video tape are on the same label.
So basically I would like to somehow group some records into one. Does
anyone have any suggestions? If I need to create a query I will need to
know how to do that because I am not very good in Access. Thanks for your
help!
 
Melissa,

It looks like to me that you have multiple shows or presentations on one
tape, no? And you want to group all shows from each tape onto one label?
It would be possible, but you would have to enter this info into a table,
with one column storing the tape number, and another column with show name.
Like this:

TapeNo ShowName
--------------------------------
001 Friends ep01
001 Seinfeld ep03
001 Bears vs Lions 12/03/02
002 CSI Miami ep12
002 NYPD Blue season finale

etc, etc, etc. Now when you make labels, you will have to make a report
that groups on TapeNo. Does this look like what you need?

Shane Andrews

----- Original Message -----
From: "Melissa" <[email protected]>
Newsgroups: microsoft.public.access
Sent: Thursday, 04 December 2003 14 11
Subject: Grouping Records

I am trying to make video tape labels and would like to group >records
Click to expand...
together so that all of the titles on the video tape are on >the same label.
So basically I would like to somehow group some >records into one. Does
anyone have any suggestions? If I need to >create a query I will need to
know how to do that because I am not >very good in Access. Thanks for your
help!
 
Back
Top