Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Seating Chart in microsoft.public.access.reports
Started 3 weeks, 3 days ago by jschping
Hi, I want to make a seating chart report for my student's finals testing. I have an Excel spreadsheet with each student's name, their room number, row number, seat number. I want to make a chart that is a visual aid to where they sit. So I don't jsut want a table listing of names and rows, I want it to come out in ...
Site: Discussions in microsoft.public.access.reports  Discussions in microsoft.public.access.reports - site profile
Forum: microsoft.public.access.reports  microsoft.public.access.reports - forum profile
Total authors: 3 authors
Total thread posts: 6 posts
Thread activity: no new posts during last week
Domain info for: microsoft.com

Other posts in this thread:

jschping replied 3 weeks, 3 days ago
They messed up my formatting. This is how it should look: ------------------------------ROOM 201 ROW 1------------ROW 2------------- ROW 3--------------- ROW 4 Jack Frost----- Amelia Earheart--- George Washington -----Joe Shmoe Marie Curie----- Abe Lincoln --------Hillary Clinton -------Marc Summers ...
Size: 2,256 bytes
Customize:  Customize "<b>Reply 1</b>: Seating Chart in microsoft.public.access.reports :: microsoft.public.access.reports :: Discussions in microsoft.public.access.reports"

KARL DEWEY replied 3 weeks, 3 days ago
If your Excel spreadsheet for room number, row number, seat number is like this -- Room Row Seat Name 201 1 1 Jack Frost 201 2 1 Amelia Earheart 201 3 1 George Washington 201 4 1 Joe Shmoe 201 1 2 Marie Curie 201 2 2 Abe Lincoln 201...
Size: 3,333 bytes
Customize:  Customize "<b>Reply 2</b>: Seating Chart in microsoft.public.access.reports :: microsoft.public.access.reports :: Discussions in microsoft.public.access.reports"

Brave Hearts replied 3 weeks, 3 days ago
Thankyou, KARL DEWEY, i have the same problem like this. now solved for your great small example... .. .
Size: 457 bytes
Customize:  Customize "<b>Reply 3</b>: Seating Chart in microsoft.public.access.reports :: microsoft.public.access.reports :: Discussions in microsoft.public.access.reports"

jschping replied 3 weeks, 2 days ago
Thanks so much for replying. I know I sound like a novice, but I don't know what a crosstab query is. Where should I paste that code that you wrote? How do I use that in a report? Thanks so much! "KARL DEWEY" wrote: > If your Excel spreadsheet for room number, row number, seat number is like > this --...
Size: 4,015 bytes
Customize:  Customize "<b>Reply 4</b>: Seating Chart in microsoft.public.access.reports :: microsoft.public.access.reports :: Discussions in microsoft.public.access.reports"

KARL DEWEY replied 3 weeks, 2 days ago
Create a new query in design view but do not select a table, click on VIEW - SQL View, and paste in the window over the 'SELECT;' you see there. -- Build a little, test a little. "jschping" wrote: > Thanks so much for replying. > > I know I sound like a novice, but I don't know what a crosstab query is....
Size: 4,714 bytes
Customize:  Customize "<b>Reply 5</b>: Seating Chart in microsoft.public.access.reports :: microsoft.public.access.reports :: Discussions in microsoft.public.access.reports"

 

Top contributing authors

Name
Posts
jschping
3
user's latest post:
Seating Chart in...
Published (2009-11-11 06:44:00)
&nbsp; Thanks so much for replying. I know I sound like a novice, but I don't know what a crosstab query is. Where should I paste that code that you wrote? How do I use that in a report? Thanks so much! &quot;KARL DEWEY&quot; wrote: &gt; If your Excel spreadsheet for room number, row number, seat number is like &gt; this -- &gt; Room Row Seat Name &gt; 201 1 1 Jack Frost &gt; 201 2 1 Amelia Earheart...
KARL DEWEY
2
user's latest post:
Seating Chart in...
Published (2009-11-11 21:26:00)
&nbsp; Create a new query in design view but do not select a table, click on VIEW - SQL View, and paste in the window over the 'SELECT;' you see there. -- Build a little, test a little. &quot;jschping&quot; wrote: &gt; Thanks so much for replying. &gt; &gt; I know I sound like a novice, but I don't know what a crosstab query is. &gt; Where should I paste that code that you wrote? How do I use that in...
Brave Hearts
1
user's latest post:
Seating Chart in...
Published (2009-11-10 19:14:00)
&nbsp; Thankyou, KARL DEWEY, i have the same problem like this. now solved for your great small example... .. . &nbsp;

Related threads on "Discussions in microsoft.public.access.reports":

Chart on Access 2007, can't format data table results....  Discussions in microsoft.public.access.reports - site profile microsoft.public.access.reports - forum profile Chart on Access 2007, can't format data table results. Why? in microsoft.public.access.reports
Chart on Access 2007, can't format data table results. Why? in microsoft.public.access.reports
Need a combination bar/line chart in access in...  Discussions in microsoft.public.access.reports - site profile microsoft.public.access.reports - forum profile Need a combination bar/line chart in access in microsoft.public.access.reports
Need a combination bar/line chart in access in microsoft.public.access.reports
Chart with access project in microsoft.public.access.reports  Discussions in microsoft.public.access.reports - site profile microsoft.public.access.reports - forum profile Chart with access project in microsoft.public.access.reports
Chart with access project in microsoft.public.access.reports
Multiple Chart function (Access 2007)-builds graphs on...  Discussions in microsoft.public.access.reports - site profile microsoft.public.access.reports - forum profile Multiple Chart function (Access 2007)-builds graphs on one page on in microsoft.public.access.reports
Multiple Chart function (Access 2007)-builds graphs on one page on in microsoft.public.access.reports
Multiple Queries for Microsoft Access Report in...  Discussions in microsoft.public.access.reports - site profile microsoft.public.access.reports - forum profile Multiple Queries for Microsoft Access Report in microsoft.public.access.reports
Multiple Queries for Microsoft Access Report in microsoft.public.access.reports
How To Export A Microsoft Access Report as a PDF?? in...  Discussions in microsoft.public.access.reports - site profile microsoft.public.access.reports - forum profile How To Export A Microsoft Access Report as a PDF?? in microsoft.public.access.reports
How To Export A Microsoft Access Report as a PDF?? in microsoft.public.access.reports
Microsoft Access Has Encountered A Problem in...  Discussions in microsoft.public.access.reports - site profile microsoft.public.access.reports - forum profile Microsoft Access Has Encountered A Problem in microsoft.public.access.reports
Microsoft Access Has Encountered A Problem in microsoft.public.access.reports
Microsoft Access in microsoft.public.access.reports  Discussions in microsoft.public.access.reports - site profile microsoft.public.access.reports - forum profile Microsoft Access in microsoft.public.access.reports
Microsoft Access in microsoft.public.access.reports
Access Pivot chart in Report in...  Discussions in microsoft.public.access.reports - site profile microsoft.public.access.reports - forum profile Access Pivot chart in Report in microsoft.public.access.reports
Access Pivot chart in Report in microsoft.public.access.reports
Access Chart Title and Axis title and Legend in...  Discussions in microsoft.public.access.reports - site profile microsoft.public.access.reports - forum profile Access Chart Title and Axis title and Legend in microsoft.public.access.reports
Access Chart Title and Axis title and Legend in microsoft.public.access.reports

Related threads on other sites:

Seating chart in microsoft.public.access.queries  Discussions in microsoft.public.access.queries - site profile microsoft.public.access.queries - forum profile Seating chart in microsoft.public.access.queries
Seating chart in microsoft.public.access.queries
Citizens Bank Park Seating Chart: Citizens Bank Park...  topichawk - Identi.ca - site profile topichawk - forum profile Citizens Bank Park Seating Chart: Citizens Bank Park Seating Chart talk right now on the Web &amp; on TopicHawk... http://tinyurl.com/dnl4sr Published about 4 months ago From twitterfeed
Citizens Bank Park Seating Chart: Citizens Bank Park Seating Chart talk right now on the Web &amp; on TopicHawk... http://tinyurl.com/dnl4sr Published about 4 months ago From twitterfeed
Rupp Arena Seating Chart: Rupp Arena Seating Chart...  topichawk - Identi.ca - site profile topichawk - forum profile Rupp Arena Seating Chart: Rupp Arena Seating Chart discussion &amp; news right now on the Web &amp; on TopicHawk... http://bit.ly/k57GH
Rupp Arena Seating Chart: Rupp Arena Seating Chart discussion &amp; news right now on the Web &amp; on TopicHawk... http://bit.ly/k57GH
American Airlines Arena Seating Chart: American Airlines...  topichawk - Identi.ca - site profile topichawk - forum profile American Airlines Arena Seating Chart: American Airlines Arena Seating Chart discussion &amp; news right now on the.. http://bit.ly/1hI4Rb
American Airlines Arena Seating Chart: American Airlines Arena Seating Chart discussion &amp; news right now on the.. http://bit.ly/1hI4Rb
WEDDINGBELLS Message Board Community: Seating chart or no...  WEDDINGBELLS Message Board Community - site profile First Steps - forum profile WEDDINGBELLS Message Board Community: Seating chart or no seating chart...
WEDDINGBELLS Message Board Community: Seating chart or no seating chart...
Seating Chart in...  Discussions in microsoft.public.sharepoint.design_and_customization - site profile microsoft.public.sharepoint.design_and_customization - forum profile Seating Chart in microsoft.public.sharepoint.design_and_customization
Seating Chart in microsoft.public.sharepoint.design_and_customization
Comcast Center Seating Chart News: Check the detailed...  Twitter / megasun - site profile megasun - forum profile Comcast Center Seating Chart News: Check the detailed Comcast Center Seating Chart Mansfield MA diagrams photo.. http://ping.fm/Kn6Lk about 4 hours ago from Ping.fm
Comcast Center Seating Chart News: Check the detailed Comcast Center Seating Chart Mansfield MA diagrams photo.. http://ping.fm/Kn6Lk about 4 hours ago from Ping.fm
Seating Chart Merge in...  Discussions in microsoft.public.word.mailmerge.fields - site profile microsoft.public.word.mailmerge.fields - forum profile Seating Chart Merge in microsoft.public.word.mailmerge.fields
Seating Chart Merge in microsoft.public.word.mailmerge.fields
Seating Chart Template for Word 2003 or Excel in...  Discussions in microsoft.public.office.templates.misc - site profile microsoft.public.office.templates.misc - forum profile Seating Chart Template for Word 2003 or Excel in microsoft.public.office.templates.misc
Seating Chart Template for Word 2003 or Excel in microsoft.public.office.templates.misc
Madrid seating chart?  BTX - site profile The Promised Land - forum profile Madrid seating chart?
Madrid seating chart?
Thread profile page for "Seating Chart in microsoft.public.access.reports" on http://www.microsoft.com/communities/newsgroups.... This report page is a snippet summary view from a single thread "Seating Chart in microsoft.public.access.reports", located on the Message Board at http://www.microsoft.com/communities/newsgroups.... This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity