Hi Pearce, Thanks for you reply. I neglected to tell you that my query looks like this:
InStr(1,[Enter course name separated by commas ],Format([Class Name],"nnnn")) > 0 I know it may be wrong for a text query, but it works. At least, it allows me to enter more then one section. How would I use your suggestion here. When I try to enter it in front of the instr, it doesn't work. BTW, the query moved itself from being criteria in the department field to it's own column. --- "Pearce, Norman" <[EMAIL PROTECTED]> wrote: > Setting the criteria as: Like [enter department > code] > > That should result in just what has been typed into > the parameter dialog > box. > > > > However if you set the parameter as LIKE [parameter > text] &"*" > > Then you will get everything that starts with the > entered text. > > > > If you enter an * into the parameter text when > running the query, you should > get all records. > > > > Hope that helps > > > > Regards > > > > Norman Pearce > > IM&T Learning Manager > > The Training Centre > > Ealing Hospital NHS Trust > > UK > > > > Developing the foundations for your success > > > > > > > > -----Original Message----- > From: jackiet_mcc [mailto:[EMAIL PROTECTED] > Sent: 23 February 2006 20:56 > To: [email protected] > Subject: [ms_access] Help with a parameter query > > > > I have a parameter query that allows the user to > enter department name, > and get the classes that members of the department > have taken. The > sections are all 4 letters starting with, QPAA, > QPAB, QPAC, etc. > However, there are three sections with less then 4 > characters, QP, QPR, > and QPA. The problem is when a user enters QPAC, > they also get QP and > QPA. > > How can I get the results of the query to be only > what the user has > entered? > > Thanks, > Jackie > > > > > > > > > SPONSORED LINKS > > > Microsoft access database > > Database development software > > Database management software > > > Database software > > Inventory database software > > Membership database software > > > > _____ > > YAHOO! GROUPS LINKS > > > > * Visit your group "ms_access > <http://groups.yahoo.com/group/ms_access> " on the > web. > > > * To unsubscribe from this group, send an > email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > > > * Your use of Yahoo! Groups is subject to > the Yahoo! > <http://docs.yahoo.com/info/terms/> Terms of > Service. > > > > _____ > > > > [Non-text portions of this message have been > removed] > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
