Extra the same value from two fields

[Guest]

Hello,

Can someone help me if it is possible to extract data from two different
fields using the same value criteria. Example I have two fields in my query
named From_Account and To_Account and they are having among other values, the
value 230 independently. I want to extract all 230 values from the two fields
without having to use [Enter From_Account] and [To_Account] against criteria
under the two fields.

Thanks for your support.

 

[Rick B]

Why don't you want to enter the same criteria under both fields? If you
copy it exactly it will only promt the user for the FROM and TO entry one
time.

 

[Guest]

Thanks. I think I'll have to leave it to prompt for both criteria.

Why don't you want to enter the same criteria under both fields? If you
copy it exactly it will only promt the user for the FROM and TO entry one
time.

--
Rick B

Hello,

Can someone help me if it is possible to extract data from two different
fields using the same value criteria. Example I have two fields in my
query
named From_Account and To_Account and they are having among other values,
the
value 230 independently. I want to extract all 230 values from the two
fields
without having to use [Enter From_Account] and [To_Account] against
criteria
under the two fields.

Thanks for your support.

 

[Guest]

I believe you miss understood Rick B.

He said to use a single prompt like --
[Enter Account]
Type it in the first criteria row under From_Account field. Then copy the
prompt and paste it under the To_Account field but on another criteria row
from where it is for the From_Account field. The reason for coping and
pasting is to make sure the prompts are identical and therefore the user will
see only one prompt but it works for both places.

Thanks. I think I'll have to leave it to prompt for both criteria.

Why don't you want to enter the same criteria under both fields? If you
copy it exactly it will only promt the user for the FROM and TO entry one
time.

--
Rick B

Hello,

Can someone help me if it is possible to extract data from two different
fields using the same value criteria. Example I have two fields in my
query
named From_Account and To_Account and they are having among other values,
the
value 230 independently. I want to extract all 230 values from the two
fields
without having to use [Enter From_Account] and [To_Account] against
criteria
under the two fields.

Thanks for your support.