I have a table that contains a filed called "Accnt_Code", the data in this field is from 1A to 9Z, what I need to do is create a parameter query, where the user may input, for example a group of Accnt_Codes, for example 1A to 1Z, and also be able to input individual Accnt_Codes, for example 2A,3B,4G - it this possible in access?

I think It is not possible in directly using query. you can do it using VBA.

urt

Help yourself by helping someone.

is there some place you direct me to, that can help with this?

I think you need to use a list box, and allow multi select, and then the user can select one or many of the parameters. You will also need to use two combo boxes, one to select the bottom of the range, like 1A, and one to select the top of the range, like 1Z, and then pass the parameters to your report.

For the top and bottom of the ranges, assuming you are running a report called "rptMyReport," try this:

Dim sStart As String
Dim sEnd As String
Dim sLink As String
Dim sDoc As String

sDoc = "rptMyReport"
sStart = Me.cboRangeStart
sEnd = Me.cboRangeEnd

sLink = "[Accnt_Code] Between '" & sStart & "' And '" & sEnd & "'"

DoCmd.OpenReport sDoc, acPreview, , , sLink

The sLink should be in the WHERE clause section of the DoCmd. line.

I can help with the code for a multi-select box if you need that. You should also validate entries in the combo boxes, and you should also use a cascading combo box so that when the user selects the start of the range, they are limited to the end of the range to only those items after the start of the range, to prevent 1C to 1A sort of entries.

Did that help?



mmcdonal

Look it up at: http://wrox.books24x7.com

It is making some kind of sense to me, my knowledge of access is limited..do I enter this in the onclick event of my list box? Thank you for your help and quick response.

The code I posted is just for two combo boxes to select the start and end of the range. You should put the code on the on click event of the button the user clicks to run the report.

Use the wizard to create the button, and then modify the button to pass the criteria.

mmcdonal

Look it up at: http://wrox.books24x7.com