Criteria to be displayed in returned field

P

Paul Dennis

I need to enter a criteria in a query (can do that) and then I need the
entered value returned in one of the fields returned.

My criteria is <["Please Enter Year (YYYY) ?"], hence the retuened year
won't all be the same, hence I need to return the criteria in a field to know
what was entered.
 
S

strive4peace

Hi Paul,

how about this:

field --> year(DateField)
criteria --> <["Please Enter Year (YYYY) ?"]

field --> YrLessThan: ["Please Enter Year (YYYY) ?"]

make sure the prompts are the same...

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
P

Paul Dennis

worked - many thx

strive4peace said:
Hi Paul,

how about this:

field --> year(DateField)
criteria --> <["Please Enter Year (YYYY) ?"]

field --> YrLessThan: ["Please Enter Year (YYYY) ?"]

make sure the prompts are the same...

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



Paul said:
I need to enter a criteria in a query (can do that) and then I need the
entered value returned in one of the fields returned.

My criteria is <["Please Enter Year (YYYY) ?"], hence the retuened year
won't all be the same, hence I need to return the criteria in a field to know
what was entered.
Click to expand...
Click to expand...
 
S

strive4peace

you're welcome, Paul ;) happy to help


Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



Paul said:
worked - many thx

strive4peace said:
Hi Paul,

how about this:

field --> year(DateField)
criteria --> <["Please Enter Year (YYYY) ?"]

field --> YrLessThan: ["Please Enter Year (YYYY) ?"]

make sure the prompts are the same...

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



Paul said:
I need to enter a criteria in a query (can do that) and then I need the
entered value returned in one of the fields returned.

My criteria is <["Please Enter Year (YYYY) ?"], hence the retuened year
won't all be the same, hence I need to return the criteria in a field to know
what was entered.
Click to expand...
Click to expand...
Click to expand...
 
Top