Access 2000 Report

  • Thread starter Thread starter BobB
  • Start date Start date
B

BobB

I need to create a simple report that draws data from two related tables.

I've gotten everything to work except:

I need to display the detail of one field horizontally instead of
vertically. For example: on a particular date I need to display the single
field's contents (maybe 10 records, maybe 25 records for the date) in a
horizontal array rather than a stacked vertical list. The the data consists
of a 6 digit number per record. On each date, the number of 6 digit numbers
may vary but should be displayed, for example, as a string of six digit
numbers 398422 398464 398522 ... The purpose is to take up less verical
space an example of the desired appearance follows:


Driver No. 001 Name Hester Jones

Wednesday, March 3, 2003 Orders

398422 398464
398522 398422 398464 398522 398422 398464 398522 398422 398464
398522 398422
398464 398522 398422 398464 398522 398422 398464 398522
398422 398464
398522 398422 398464 398522 398422 398464 398522

Thursday, March 4, 2003 Orders

398422 398464
398522 398422 398464 398522 398422 398464 398522 398422 398464
398522 398422
398464 398522 398422 398464 398522 398422 398464 398522
398422 398464
398522 398422 398464 398522 398422 398464 398522

The string of numbers represent the data in the records of the main table
TagID Field.

Any suggestions will be deeply appreciated.

By the way, I am just a beginner. Thanks for patients.

BobB
(e-mail address removed)
(e-mail address removed)
 
Bob,

What you are asking for can be done, although it may require
the use of Recordsets in VBA coding, which if you are 'just
a beginner' may be a bit of a challenge. The basics would be
to open a recordset and then roll through it and add each
desired value to a string variable that you can then
display. If you want a code sample on this, post back and
someone can provide that if you give the details on your
field and table names.

I am really confused when you say...

"The string of numbers represent the data in the records of
the main table TagID Field."

All of these numbers reside in one field? Or this is data
from a second table that is related to TagID in the main
table?

I do have to ask, after looking at your desired output, how
seeing these is really useful in a report. If I was a
restaurant manager, I don't think that I would like to see
the numbers of every dinner ticket that a given server used.
I would more likely want to know how many steaks, how many
chickens, how many people and how many tables were served
and then, if needed a way to find out what was sold on each
ticket for auditing.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Back
Top