Parameter in Query by Two seprate Form Field (1 Viewer)

[ootkhopdi]

Sir

i want to set parameter in my select query with or function
as in detail
i have two form with same field
1-with field A
2-With Field A

now i want to select data for a table .with a parameter select with Field A in form 1 or Field A in Form 2
How can i do it
:banghead:

 

[ChristopherL]

Hi, can you please explain a bit better? I don't completely understand what you want to do? But if you want to select certain values from two forms with the same columns and unite them, you can use union all and have a where statement for each form?

Sir

i want to set parameter in my select query with or function
as in detail
i have two form with same field
1-with field A
2-With Field A

now i want to select data for a table .with a parameter select with Field A in form 1 or Field A in Form 2
How can i do it
:banghead:

 

[ootkhopdi]

Hi, can you please explain a bit better? I don't completely understand what you want to do? But if you want to select certain values from two forms with the same columns and unite them, you can use union all and have a where statement for each form?

How can i so it
Means how can i union all

 

[ChristopherL]

How can i so it
Means how can i union all

Hey sorry for late answer but I have been out of office.

select fieldA from form1
union all
select fieldA from form2

you have to write in the sql editor.

 

[ootkhopdi]

Hey sorry for late answer but I have been out of office.

select fieldA from form1
union all
select fieldA from form2

you have to write in the sql editor.

thankyou very much.

 

[ChristopherL]

Glad I could help, good luck!
Regards,
C

thankyou very much.