A
Access rookie
Hello,
I'm running a report based ona query with wildcards. I can run the query
accurately, but when I run the report, similiar fields do not show up.
For example, I have Roosevelt Teddy and Roosevelt Theordore. The query
wildcard is Like "*" [Enter part of last name:] & "*" .
The report returns results with only one name displayed and doesn't separate
them both. It combines the different values I entered in the fields for Teddy
and Roosevelt. The query gives me the right answers. Why doesn't the report
based on the query do the same thing?
I'm running a report based ona query with wildcards. I can run the query
accurately, but when I run the report, similiar fields do not show up.
For example, I have Roosevelt Teddy and Roosevelt Theordore. The query
wildcard is Like "*" [Enter part of last name:] & "*" .
The report returns results with only one name displayed and doesn't separate
them both. It combines the different values I entered in the fields for Teddy
and Roosevelt. The query gives me the right answers. Why doesn't the report
based on the query do the same thing?