Field list itself a parameter?

[Ofina]

One of my users wants a report in MS Query (Excel) to send to customers or suppliers where he can tell it which fields to include on the report for the specific situation at hand.

Now, to me, this sounds almost as if he wants to create the report from scratch each time, just with a subset of available fields (rather than the whole database) and a different interface (the parameter interface, rather than the straight coding interface).

Is there any way that any of you know for me to make a field listing itself a parameter?

 

[SkipVought]

Hi,

You cannot choose a field using a parameter.

You can, however, use VBA code to select a particular field.

But this raises a [red]RED FLAG[/red], IMHO. Out of curiosity, what are the Fields that this user wants to be able to select. I would GUESS, that these Fields are probably DATA VALUES rather than data designations (for instance customer names vs Customer, containg customer names)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Ofina]

No, it's not the values that he wants. Well, actually, he does, but I already know how to do that. He wants to be able to choose whether to put customer name on the report, or supplier $s open, or whatever, depending on the given situation.

I think I have a possible solution in Crystal reports, though.

 

[SkipVought]

I'd use a macro, then.

If CR does not work for you or you want another solution option, please post your question in Forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}