Re: Variabel fieldnames in queries

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:33:41 CEST