C
Chris43
Access 2007
I am doing a very simple report on a very small one table database. The
table consists of account#, first & last name, and a date. My query prompts
for first name and last name. I use wildcards so I just enter first 1 or 2
letters for each input. In Datasheet view the data returned by the query is
correct: complete first and last names and associated fields. However a
report based on this query uses only the characters that were entered for
first and last name, ie "a smi" instead of "Adam Smith". I know this is
something simple, but I cannot figure it out.
Thank you,
Chris
I am doing a very simple report on a very small one table database. The
table consists of account#, first & last name, and a date. My query prompts
for first name and last name. I use wildcards so I just enter first 1 or 2
letters for each input. In Datasheet view the data returned by the query is
correct: complete first and last names and associated fields. However a
report based on this query uses only the characters that were entered for
first and last name, ie "a smi" instead of "Adam Smith". I know this is
something simple, but I cannot figure it out.
Thank you,
Chris