G
Guest
Hi there, I created a parameter query that would prompt for a "country code"
to be inputted to gather results. Data from this is based on a query that
contains staff info and the country where they own real estate, namely: NM,
KO, PH, FR and ALL (for all countries).
The problem that I am encountering is this: I can pull results by entering
"ALL" in the prompt, but couldn't get any when I entered the other codes. I
am not sure why my results are blank when I know for a fact that there are
records tied to those countries coded other than "ALL".
I am not sure if it has something to do with the properties of that field.
Please help!
Thanks, Marie
to be inputted to gather results. Data from this is based on a query that
contains staff info and the country where they own real estate, namely: NM,
KO, PH, FR and ALL (for all countries).
The problem that I am encountering is this: I can pull results by entering
"ALL" in the prompt, but couldn't get any when I entered the other codes. I
am not sure why my results are blank when I know for a fact that there are
records tied to those countries coded other than "ALL".
I am not sure if it has something to do with the properties of that field.
Please help!
Thanks, Marie