Still cannot figure out how to make this happen

[kaim]

I wanted to make this more clear...

I have an auto number

ID PrevRecNum
1 Some Data 0
2 Some Data 1


3 Some Data 1
4 Some Data


I want to be able to create an query if ID = [Some Number] I will use 1 for example i would like it to pull that record while at the same time if PrevRecNum = [Some Number] again using 1 as the example it will also pull record 2 and 3 giveing me a completed query containing racords 1 2 and 3........ I would like to be able to change the number hince the reason i used the [Some number variable] Please any help would be great. i have been at this for almost a week.

[June7]

And what have you tried? What happened - error message, wrong results, nothing?

Did you build a dynamic parameterized query?

You want to pull records where the given number is the ID or is in PrevRecNum?

Try:

SELECT * FROM table WHERE ID=[some number] OR PrevRecNum LIKE "*" & [some number];

I NEVER used dynamic parameterized query - I prefer http://www.allenbrowne.com/ser-62.html

[kaim]

i would like to pull both if 1 is in the ID field Pull the record and display

If 1 is in the PrevRecNum field i would like it to Pull this aswell and display with the ID.


Does this make sense?

[June7]

Did you try my suggestion?

[kaim]

Thanks so much,

Its working like a charm.....

*Bows* To the master