I'm Sorry.
As I see I've selected not the correkt forum for my question.
But if there anybody speaking German I'm very happy for every answer.
bye
>Moin zusammen,
>
[quoted text clipped - 21 lines]
>Grüsse aus dem Norden
>Markus
Rog - 28 Feb 2005 10:14 GMT
Markus,
As for the first question:
"select '(alle)' from yourtable union select yourfield from yourtable;"
I can try to reply to your 2nd question if you can rephrase it in
English.
TonyR - 28 Feb 2005 16:52 GMT
> >Moin zusammen,
> >
[quoted text clipped - 15 lines]
> >Mit der Funktion will ich die Spalten im Listenfeld dynamisch füllen,
> >je nach vorher getroffener Auswahl.
A translation of the second question:-
Once upon a time I did that with a user defined function, but can no
longer understand the thinking behind it and cannot find it in my
databases.
A further remark
With the function mentioned in question 2 I want to fill in a list box
with field values which come from a pre-determined pivot query.
______________________________________
My outline suggestion to solve this
Make an SQL query which gathers the required data for the columns and
use it as the listbox's RecordSource, having decided on the column
count and bound column of the listbox, then refresh of requery the
list box.