Q: Filtering from a form with spaces

M

MarkD

Hi,

I'm using Access 2000. I posted this yesterday, but I
think the post was a little long-winded.

I have a sales table with the field [salesperson] with the
following 4 names:
Homer Simpson
Bart Simpson
Marge Simpson
Lisa Simpson

On a form, I want the user to be able to select 1 or more
rep names, let's say
Homer Simpson
Bart Simpson

How to I pass this information from the form (say, from a
text box) to the filter criteria in the query? The way I
normally would do it doesn't work because Access is
getting confused because there are spaces in the name.

Thanks,
-Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Q: Passing form text (with spaces) to a query (Access 2000) 1
Advice/best practice needed maybe some complex VB aswell 4
Advice/best practice needed 2
Help creating a search form in Access XP 0
Creating groups of people with different background 2
Creating groups of people with different background 0
Expandable list in report? 2
Word 2007 Mail Merge puts in a space for empty fields from Excel 2 4

Top