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/
