Developer Forum

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.

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
*

worked - many thx

you're welcome, Paul ;) happy to help


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