Parameterized Query->using the value in more than one place

[ankursaxena]

Hi, I want to be able to write a parameterized query where I take in the username and then search a select * from where username X UNION select * from where username X..

Can this be done, I want to generate a report which will take the output of this, or is there a quick way of doing this using a small form and vba? to populate a report in Ms Access..Thanks

 

[ankursaxena]

Thanks guys cuz of tennisguy's question and crowley16's answer I am able to do this, I found the solution on the next page, should have looked, but initially I thought I had an unsual requirement..anyhow..I guess other people also need to do unsual things

Thanks anyways..