Criteria to be displayed in returned field

Criteria to be displayed in returned field

Post by UGF1bCBEZW » Fri, 03 Nov 2006 18:20:01


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.
 
 
 

Criteria to be displayed in returned field

Post by strive4pea » Fri, 03 Nov 2006 18:39:32

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
*

 
 
 

Criteria to be displayed in returned field

Post by UGF1bCBEZW » Fri, 03 Nov 2006 19:25:01

worked - many thx
 
 
 

Criteria to be displayed in returned field

Post by strive4pea » Sat, 04 Nov 2006 17:17:42

you're welcome, Paul ;) happy to help


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