Re: Variabel fieldnames in queries

You may have to get creative with the "OR"'s, there are only 9 rows in the QBE grid.

On Fri, 06 Jul 2001 01:14:18 GMT, b <bjl_at_att.worldnet.com> wrote:

>Use" Like Forms!frmName!FieldName & *" .
>Repeat this for each field using the "OR" criteria
>
> , etc.
>
>Be sure you keep using the next lower row for each one
>
>Like Forms!frmMN!field1 & "*"
> Like Forms!frmMN!field2 & "*"
>
>Hope this helps
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>On Wed, 04 Jul 2001 13:04:40 GMT, "R. Groot Beumer" <Info_at_RGBplus.nl>
>wrote:
>
>>Hello (again),
>>
>>I have a question about the use of variabel fieldnames in queries. In a
>>table of mine I've worked with cummulatives. The tables has got (among
>>others) 13 fields which are named: cm_01, cm_01, cm02 etc (last one is
>>cm_13).
>>In a certain query I want to get the values of one of the above fields by
>>using a variabel (perhaps a function). So the user is asked: "Which period
>>do you want to export". The system must take the right field. In simple VBA
>>this is done with: Me("cm_" & [period]) but how is this done within a
>>query.
>>
>>As usual: any help is appreciated !!
>>
>>Thanx,
>>
>>Remco (Holland)
>>
>
  Received on Sun Jul 22 2001 - 01:34:39 CEST