Grouping Records

M

Melissa

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!
 
W

Wayne Morgan

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
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!
 
S

Shane Andrews

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
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top