Between Months in a query

G

Guest

I am using access 97. In my reference field, the reference I type into the
field is month & number & year the numbers start at 1 each month eg
(July01/05. july02/05) The paramentor I have set up is: eg
Like [Please Enter Serial Number July*05] This runs only one month off at
a time, which I need. But I also need to run 3 or 4 months off to gether and
not sure how to do this.
 
M

[MVP] S.Clark

Between the unnormalized data, and the use of the parameter query, you're
really kinda stuck.

Maybe if you create a form and put a multi-select list box on it, then parse
the selected values into an IN clause. But that takes a little VBA know how.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting
 

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

Date field 2
Month and YTD Values 1
Identify closed/finalized records the month they were opened Acces 2
Cumulative counts in a query 2
Adding months to a given date 2
Date Brackets as an IIf statement 3
Query Problem 1
Crosstab Query & Month Names 3

Top