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]

"Steve" <ac******@netins.net> wrote in message
news:bo**********@news.netins.net...

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?

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]

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:bo*************@ID-98015.news.uni-berlin.de...

"Steve" <ac******@netins.net> wrote in message
news:bo**********@news.netins.net...

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?

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

Thanks Rick, I'll give it a try

Steve