Query Help

[Steve]

Hello,

I'm currently trying to pass a global variable to a query criteria with
no luck. This query passes information to a report Is it possible to do
this?

V/R
Steve

[Rick Brandt]

Re: Query Help

"Steve" <acrvpocf@netin s.net> wrote in message
news:booau4$519 $1@news.netins. net...[color=blue]
> Hello,
>
> I'm currently trying to pass a global variable to a query criteria[/color]
with[color=blue]
> no luck. This query passes information to a report Is it possible to do
> this?[/color]

Queries cannot use variables directly, but if you create a one line
function that returns the value of the variable the query can use that.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Steve]

Re: Query Help

"Rick Brandt" <rickbrandt2@ho tmail.com> wrote in message
news:boob10$1g9 mhh$1@ID-98015.news.uni-berlin.de...[color=blue]
> "Steve" <acrvpocf@netin s.net> wrote in message
> news:booau4$519 $1@news.netins. net...[color=green]
> > Hello,
> >
> > I'm currently trying to pass a global variable to a query criteria[/color]
> with[color=green]
> > no luck. This query passes information to a report Is it possible to do
> > this?[/color]
>
> Queries cannot use variables directly, but if you create a one line
> function that returns the value of the variable the query can use that.
>
>
> --
> I don't check the Email account attached
> to this message. Send instead to...
> RBrandt at Hunter dot com
>
>[/color]

Thanks Rick, I'll give it a try

Steve