Need building help

I have 6 hyperlinked reports that I get weekly. I keep them in the same
folder and I keep the same names for each respecting unit.

I am having trouble trying to combine all 6 into a single report so that I
can query it through a master roster. Another issue is that after some of the
names people accidently type a space and it is causing the query to regester
it as a change in the name.

When I run the full report through the query I don't want it to recognize
the space as an error. I have more the 15k names, the first and last names
are seperated into seperate columns. It would take to much time to erase all
the space errors, then to just make it not recognize them when running the
query.

You can remove leading spaces with the LTrim function, remove trailing
spaces with the RTrim function and remove both leading spaces and trailing
spaces with the Trim function.

Steve



"Kuzac" wrote in message
...
I have 6 hyperlinked reports that I get weekly. I keep them in the same
folder and I keep the same names for each respecting unit.

I am having trouble trying to combine all 6 into a single report so that I
can query it through a master roster. Another issue is that after some of
the
names people accidently type a space and it is causing the query to
regester
it as a change in the name.

When I run the full report through the query I don't want it to recognize
the space as an error. I have more the 15k names, the first and last names
are seperated into seperate columns. It would take to much time to erase
all
the space errors, then to just make it not recognize them when running the
query.