Diverse records in one string

  • Thread starter Thread starter Blackstar
  • Start date Start date
B

Blackstar

Hi,

I have following questions.

I would like to add diverse dates in a table to one string
example 1: diverse data between 13 jan and 4 febr
how I want it to look: 13, 17, 24, 30 januari and 2, 4 februari 2008
(It should really look like that)

And then I have a table with items and the amount of those Items.
I would like to see those as follows
example 2: lijst met zaken en hun hoeveelheid (dus veld zaak en veld
hoeveelheid)
how it should look: Item:Amount, Item2:Amount, Item3 etc...

Could someone help me here please.
I got on proposition on a foreign site, but colums are not really an option
for me.

Hope to get this working somehow.

regards,
Didier
 
Why do you need to do this? What are you trying to achieve?
Do you want the output to be in a table or in a report?

-Dorian
 
Hi,

Thnx for the interest.
First of all, i would like to use it in a form for visual purposes, but I
also need it in a report, and their it is because I cant make the report to
long.
In the mean time I found a way to work with the dates, someone gave me an
answer on that already, but not on the second question.

I will explain it more precise for you.
I work with musicians.
each production/concert/opera consists of an amount of musicians.
For archiving purposes outside the DB and to give to other production
houses, we need to make a visual attractive and clean overview of that
production.
Therefore I would like a list of the musicians that played.
Violin (12), Contrabas (6) etc etc etc

Their is a kind of rule that is used in the classic music world on how to
show that list.
They even use short code fl=flute cb= contrabas, etc etc, but I don't want
to do that, cause it would make it way to difficult. And in case I would
wanna use that, that is an option I can work around myself by making a
shortcode for each instrument.

So if you can help me, I would really appreciate it.

regards,
Didier
 
I would suggest:

Store the data in a properly normalised table, it only makes life difficult
later if you don't. So for example your list of dates should be one date per row.

For your formatting write a function that processes a recordset and builds the
string in the form that you want.

The instrument codes are similarly straight-forward from a normalised table,
just include the instrument code in another column in the table with the
instrument name. You can then retrieve whichever you prefer for each form or
report.

HTH
John
##################################
Don't Print - Save trees
 
Back
Top