Hi Everyone,

Access 2003. I have a query that I have set up so the user can type in
in a txtbox (in a form) the year (string) and the query workks great. This
is my parameter:
Like [Forms]![Search].[txtYyear] & "*"

1. I would like to include a criteria to search between two years in the
same txtbx. Could you suggest me how to do it?

2.In the same query I have another parameter:
Like [Forms]![Search].[txtTwn] & "*"
This allow me to write only one word in a txtbx same form), but I would like
to write two or three words.Could you help me?

Your help is greatly appreciated


.. They pull data for the month so the first date they enter
is 3/1/10 and the end date is 3/31/10. I want all records between these
dates but anything that is 3/31 doesn't show up inless I type in 4/1. Is
there a way I can add something in the expression so it automatically adds
the one day?