Re: Variabel fieldnames in queries
From: Douglas J. Steele <djsteele_at_canada.com>
Date: Sat, 07 Jul 2001 22:50:19 GMT
Message-ID: <LmM17.434128$eK2.88119963_at_news4.rdc1.on.home.com>
Date: Sat, 07 Jul 2001 22:50:19 GMT
Message-ID: <LmM17.434128$eK2.88119963_at_news4.rdc1.on.home.com>
Except that you can, of course, always insert more rows (Insert | Rows from the menu bar)
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele/ "Scott Barrow" <ScottMBarrow_at_aol.com> wrote in message news:3b486061.101602726_at_news...Received on Sun Jul 08 2001 - 00:50:19 CEST
> 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)
> >>
> >
>